Hi Dave :
I'm in the Construction industry (20 years)

The only drawing I seen expressed in 16nth was a truss drawing
your not in the truss business are you?

Construction 16ths come on!

I must be missing something here if not, try entering the number as follows.

whole number space numerator/denominator

Whole number spacebar numerator / denominator
5 10 / 16
results
5 5/8 and still has the integerity of a number

Good Luck
TK


"Ron Rosenfeld" wrote:

On Thu, 28 Oct 2004 13:33:34 -0400, "Dave B" wrote:

Can Excel display fractions for distances (measured in inches) with the
lowest common denominator?

For example...
5 8/16 (5.5) displayed as 5 1/2
3 10/16 (3.625) displayed as 3 5/8
1 13/16 (1.8125) displayed as 1 13/16

I'm amazed I haven't been able to find an answer to this on Google. You
would think with the construction industry being so large that this would be
a piece of cake. I've played around with Custom Number Format but haven't
found a solution. Any ideas?


Apply this formula to your results if you want display to the closest 1/16th
rounded to the LCD:

=ROUND(A1*16,0)/16

Format the cell as fraction with up to two digits
# ??/??


--ron