Reduction Fractions to LCD
Hi,
Have you tried a custom format: # 0/0
HTH
Jean-Guy
"Chad" wrote:
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
|