Fraction in 16ths format reduced to LCD:converting it into inches

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.

Format Cells>Number>Custom

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

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Derek" <[email protected]> wrote in message
news:[email protected]...
>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.