Fraction in 16ths format reduced to LCD

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Text fraction to fraction format 1
Fractions in 16ths format - reducing to LCD 4
How to format numbers as architectural fractions (1/16,1/8,1/4 ) 5
In Excel 2003 display 8/16 as 1/2 and 4/16 as 1/4 2
Extract numerator from fraction 9
Where to get 32nds as a number format in Excell or how to keep f 2
How can I keep a fraction from being reduced? 3
Excel Excel and Fractions 3

Top