ExcelBanter - format number in feet and inches

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - format number in feet and inches (https://www.excelbanter.com/excel-discussion-misc-queries/14606-format-number-feet-inches.html)

emerald

format number in feet and inches

Id there a way to format a number to feet and inches, i.e 6.25 to display as
6' 3"??

Jason Morin

Try:

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

HTH
Jason
Atlanta, GA

-----Original Message-----
Id there a way to format a number to feet and inches,
i.e 6.25 to display as
6' 3"??
.

All times are GMT +1. The time now is 07:10 PM.