# Thread: Displaying fractions in Excel

1. ## Displaying fractions in Excel

Is there a way if displaying a fraction in Excel in a better way than just '6 1/2' (6.5) ,
eg. putting the vulgar fraction in smaller letters than the main number?
Excel 2000

2. ## Re: Displaying fractions in Excel

You mean like this?
1/2 is CHR189 - are you looking for an infinite range - or just the quarters?
(188= 1/4, 190 = 3/4)

3. ## Re: Displaying fractions in Excel

How do you do that?

[img]/S/bow.gif[/img]

4. ## Re: Displaying fractions in Excel

I think Word only does it a with a limited number of fractions, like the quarters and half and it seems to use the extended characters that Leif referred to. They can be used but will treated like text by Excel. to enter a half, Hold down the ALT key and enter 0189 on the numeric keypad. Doing that you are entering text, not a number.

If you want to format your numbers and results as proper fractions, then the answer appears to be no.

Andrew C

5. ## Re: Displaying fractions in Excel

How did I insert the fraction?
I cheated. Went to Word, insert symbol, copy'n'paste. [img]/S/smile.gif[/img]

If you want to make it auto-correct (how I did it):
In Word, type '1/2' - which is converted to

6. ## Re: Displaying fractions in Excel

These symbols presumably do not evaluate to the values that they show, and so could not be used in formulas etc.

Maybe I am incorrect but I would assume that the formatting is required for numerical data.

Andrew C

7. ## Re: Displaying fractions in Excel

Very true.
But if it is only for cosmetic reasons, it may do the job - though who would want to use some of those fractions is beyond me.

8. ## Re: Displaying fractions in Excel

If you have the MS Reference 2 font installed, you have access to a whole range of fractions.

9. ## Re: Displaying fractions in Excel

Actually, Word does it better than you can do with Excel. Using Word's equation editor, you can create an fraction you want, and with a horizontal line vs the slanted line.

10. ## Re: Displaying fractions in Excel

The equation editor objects can be embedded in Excel also, put not to format Excel data. It is purely cosmetic.

Andrew C

11. ## Re: Displaying fractions in Excel

Just Format the cell using Fraction style. You have a choice of detail. The roll your own form is # ???/???.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•