View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph David Biddulph is offline
external usenet poster
 
Posts: 620
Default Reduction Fractions to LCD

You could format in fractions with up to one or two or three digits, rather
than in 1/8 increments.
--
David Biddulph

"Chad" wrote in message
...
I've got a formula that I want to read in a fraction (i.e. 14 1/2 instead
of
14.5). I've formatted the cells to read as a fraction in 1/8 increments.
The problem is I sometimes get things like 14 4/8, instead of the LCD and
being reduced to 14 1/2. Any suggestions on how to get around this and
display the lowest common denominator? Thanks.

-Chad