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., # ??/??


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


This link should answer your question: