For example how to convert 13.25' to 13'-3" ?
M Mike H Feb 23, 2010 #2 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.
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.