View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Billigmeier
 
Posts: n/a
Default Fractions show as dates

When you first enter it put a 0 before the fraction, i.e. to enter 7/16 enter
it exactly like this:
0 7/16

This will tell excel you're entering a numerical fraction instead of a date.
--
Regards,
Dave


"ross" wrote:

My fractions show as dates. Can you advise on this, please? I appreciate
this newsgroup. Dick Ross