Formating fractions so they read like a measuring tape

G

Guest

How to format a fraction so it only displays as 1/64th, 1/32nd, 1/8th, 1/4,
1/2, etc. not 7/9 or 3/7, 2/5, or 1/3 etc. In other words, how do you format
fractions so they read like a measuring tape?
 
B

Bernard Liengme

Needs more that just formatting. Use =ROUND(A1*16,0)/16 with format Fraction
up to 2 digits

best wishes
 

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

rounding down to nearest 1/32 3
show fractions rounded up to nearest 1/16th inch 15
Excel Excel and Fractions 3
architectural fractions 8
How to format numbers as architectural fractions (1/16,1/8,1/4 ) 5
Formatting Fractions 3
Fraction Symbols. 2
Not reduce fractions 8

Top