MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Fraction display of 5/8


Posted by Nick on December 03, 2001 12:55 AM

I am trying to get Excel to display financial fractions as one character. 1/2, 1/4, 3/4 seem to be available but I am struggling with 1/8, 5/8, 3/16, 1/32 etc. Is there any way of displaying these? Am I limited by ASCII characters?


Posted by Aladin Akyurek on December 03, 2001 1:02 AM

Try Custom format, e.g., # ??/??

Aladin

Posted by Bariloche on December 03, 2001 5:06 AM

Nick,

This link should answer your question:

http://www.geocities.com/davemcritchie/excel/fractex1.htm


enjoy