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
 

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
How to format numbers as architectural fractions (1/16,1/8,1/4 ) 5
Fractions in 16ths format - reducing to LCD 4
Fraction to Decimal 2
In Excel 2003 display 8/16 as 1/2 and 4/16 as 1/4 2
How do I combine/join multiple formulas 2
How can the font and size of (all) citation numbers be altered? 1
Help with formula (decimal to fraction) 2

Top