Number Formats

T

Tim Bentley

I use excel at work to calculate varying lengths of
reinforcing, and I was wanting to format cells to reconize
that for example 21.354 = 21'-4 1/4" but I am having a
difficult time getting it to work correctly. Can you
please provide me any assistance you can with this
problem, before I pull my hair out.

Thanks for any assistance you can provide...
 
J

JohnI in Brisbane

Tim,

with 2.354 in A2, put the following formula in A3 -

=INT(A2)&"' "&TEXT((A2-INT(A2))*12,"# ?/?")&""""

regards,

JohnI
 
Top