convert cm to feet & inches when the cell is formatted with cm?
Convert cm to feet & inches when the cell is formatted with cm? I got this formula in from the Apple community:
INT(ROUND(A1×0.3937,0)÷12)&"ft. "&MOD(ROUND(A1×0.3937,0),12)&"in."
I use this for converting in. to ft. & in.:
FIXED(TRUNC(P35÷12),0)&" ' "& FIXED(MOD(P35,12),0)& """"
Thanks in advance
MacBook Pro 15″, macOS 10.15