View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default how display 12/3 as fraction?

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Ian Elliott" wrote:

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