From: John on 23 Feb 2010 08:59 For example how to convert 13.25' to 13'-3" ? From: Mike H on 23 Feb 2010 09:08 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" wrote: > For example how to convert 13.25' to 13'-3" ? From: Mike H on 23 Feb 2010 09:10 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" ? From: Rick Rothstein on 23 Feb 2010 09:12 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 news:B5FA64B6-7F8E-4B3C-A217-586768DEAF51(a)microsoft.com...> For example how to convert 13.25' to 13'-3" ?