View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default Entering and displaying fractions

It will reduce unless you specify the denominator in the format, such as
#?/52

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Chris Price" wrote in message
...
I want to enter and display a fraction as 4/52, but this is converted to
1/13. Is there a way I can avoid Excel converting?
--
Chris Price