ExcelBanter - Convert decimals to feet / inches in excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Convert decimals to feet / inches in excel (https://www.excelbanter.com/excel-programming/329589-convert-decimals-feet-inches-excel.html)

rk@morsesteel

Convert decimals to feet / inches in excel

Can you format a cell to convert decimals to feet & inches
i.e. 10.250 to 10'-3"

Bob Phillips[_7_]

Convert decimals to feet / inches in excel

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

--
HTH

Bob Phillips

"rk@morsesteel" wrote in message
...
Can you format a cell to convert decimals to feet & inches
i.e. 10.250 to 10'-3"

rk@morsesteel[_2_]

Convert decimals to feet / inches in excel

That solved a long existing dilema, now I just need to figure out how to
incorporate it into my workbook. Thank You

"Bob Phillips" wrote:

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

--
HTH

Bob Phillips

"rk@morsesteel" wrote in message
...
Can you format a cell to convert decimals to feet & inches
i.e. 10.250 to 10'-3"

All times are GMT +1. The time now is 06:49 AM.