Fraction in 16ths format reduced to LCD

D

Derek

I have size data given in millimeters and converting it into inches in 16ths
fraction format. How do I reduce resulting fractions to lowest term - I don't
want to see 8/16 but do want 1/2.
 
N

Niek Otten

Format Cells>Number>Custom

In the Type box, enter # ??/??

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Top