how display 12/3 as fraction?

  • Thread starter Thread starter Ian Elliott
  • Start date Start date
I

Ian Elliott

Thanks in advance for any help.
I tried to display 12/3 as "12/3" in a cell by formating as fraction, with
up to 2 digits, but it just shows 4.
Any ideas on how to show as 12/3?
Thanks
 
The basic fraction format for two numbers is actualy (look under custom)
# ??/??
you could modify this to:
??/??
however, XL uses its knowledge and will always try to reduce fractions, thus
12/3 would be displayed as 4/1.

If you really need to display 12/3, you will first need to format the cell
as text, before inputting your value.
 
Type a single apostrophe before "12/3" -- '12/3. The apostrophe will not
display, but it lets Excel know that the content is text.
 
thanks Niek, that worked the best-I didn't have to change text to values
afterwards.
 
Back
Top