Fractions in 16ths format - reducing to LCD

D

Derek

I have data in millimeters and converting in aanother cell to inch fractions
in 16ths format (result must be in 16 increments). How do I reduce to LCD - I
do not want to see 8/16 but do want 1/2.
 
B

Bob Phillips

You have an answer elsewhere.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
R

Ron Rosenfeld

I have data in millimeters and converting in aanother cell to inch fractions
in 16ths format (result must be in 16 increments). How do I reduce to LCD - I
do not want to see 8/16 but do want 1/2.

Round your result to the nearest 16th, and format the cell as a fraction with
up to two digits.

To round:

=ROUND(your_formula*16,0)/16

Format code:

# ??/??


--ron
 

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

Top