Format CellsNumberCustom
In the Type box, enter # ??/??
--
Kind Regards,
Niek Otten
Microsoft MVP - Excel
"Derek" wrote in message
...
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.
|