OT Fractions in Excel 2007
Tom Rex in TX
I want to display numbers as fractions in their lowest common denominator.
I have thicknesses of lumber that are 3/16, 1/4, 3/8, 3/4, 1 1/4, etc.
To be able to display the 3/16 I have to choose Number, Fraction, as sixteenths.
But I would like the other fractions to diplay as 1/4 (not 4/16) 3/8 (not 6/16) etc.
Is this possible and how do I do it.
Thanks,
T Rex




