View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Doug Kanter
 
Posts: n/a
Default Fractions show as dates


"ross" wrote in message
...
My fractions show as dates. Can you advise on this, please? I appreciate
this newsgroup. Dick Ross



From the Excel 2000 help system - see below. As with some other cell
formats, this one seems to only work (or work most often) if the formatting
is done before the data is entered.

Show numbers as fractions
1.. Select the cells you want to format.


2.. On the Format menu, click Cells, and then click the Number tab.
Show Me

3.. In the Category list, click Fraction, and then click the type of
fraction you want to use.




Attached Images