1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Excel 2000

Discussion in 'Business Applications' started by willadene, Apr 26, 2004.

Thread Status:
Not open for further replies.
  1. willadene

    willadene Thread Starter

    Joined:
    Aug 24, 2003
    Messages:
    105
    Working with fractions.
    Can't a person enter 3/4 so it is fraction character or small like in Word? The only topic related to fractions that I see is in format cell-number where a person can designate 33/100 or 1/2. Any insight appreciated. Thanks.
     
  2. Anne Troy

    Anne Troy

    Joined:
    Feb 14, 1999
    Messages:
    11,746
    First Name:
    Anne
    The ability to enter fractions *on the fly* is done by using Cell Formatting. If you want the *ordinals* like Word uses, then the easiest way to do it is to insert them into Word and copy them over.

    The thing is, Excel won't see them as values that way, but only as text. Let us know if you need more information. :)
     
  3. XL Guru

    XL Guru

    Joined:
    Aug 30, 2003
    Messages:
    2,702
    As Anne says. If you are after text, I think Excel XP (2002) has Insert Symbol, a la Word. You can create some as superscript/subscript, but it's limited and depends on the font ; http://www.cpearson.com/excel/chars.htm may be useful.

    ALT+0188, 0189, 0190 = ¼, ½, ¾ respectively. You could consider AutoCorrections, e.g. replace 1/2 with ALT+0189, but assuming you're "that side" of the pond you'd have to watch for dates (such as 1/2/04).

    Rgds,
    Andy
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/224116

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice