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

M

Mike H

John.

With your decimal value in a1 try

=INT(A1)&"' "&INT(12*(A1-INT(A1)))&""""
--
Mike

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