Excel number formatting to show feet and inches 1

[waters130]

I have a spreadsheet where I have dimensions entered in as feet. I would like to be able to format the text so that it shows in feet and inches.

For example 7.25 would be shown as 7' 3"


Thanks,

waters130

 

[yogia]

I have a spreadsheet where I have dimensions entered in as feet. I would like to be able to format the text so that it shows in feet and inches.

For example 7.25 would be shown as 7' 3"

Hi waters130:

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





Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC

http://www.energyefficientbuild.com