How to change decimals of length in feet to feet and inchs
in [General]
|
Prev: Inserting an Object from a different workbook - please help
Next: Data Validation message increases file size?
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" <John(a)discussions.microsoft.com> wrote in message news:B5FA64B6-7F8E-4B3C-A217-586768DEAF51(a)microsoft.com... > For example how to convert 13.25' to 13'-3" ? |