How to change decimals of length in feet to feet and inchs
 

For example how to convert 13.25' to 13'-3" ?

How to change decimals of length in feet to feet and inchs
 

see your other post
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"John" wrote:

For example how to convert 13.25' to 13'-3" ?

How to change decimals of length in feet to feet and inchs
 

If you are talking about showing your conversion in another cell, then you
can use this formula...

=INT(A1)&"'-"&12*MOD(A1,1)&""""

--
Rick (MVP - Excel)


"John" wrote in message
...
For example how to convert 13.25' to 13'-3" ?