Number Formats

  • Thread starter Thread starter Tim Bentley
  • Start date Start date
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...
 
Tim,

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

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

regards,

JohnI
 
Back
Top