convert cm to feet & inches when the cell is formatted with cm?

Question

Level 1

4 points

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

Posted on Dec 6, 2023 7:01 AM

Reply

Answer 1

Level 8

37,538 points

You can try something like this:

Input as:

=TRUNC(A2/2.54/12)&" ft. "&ROUND(MOD(A2/2.54,12),0)&" in"

SG

Reply

Answer 2

Level 4

1,633 points

To eliminate the propagation of the custom format (3160 cm) and thus go from

118 cm ft. 1 cm in

to

118 ft. 1 in

you need to convert the numbers to strings with FIXED

=FIXED(A3÷2.54÷12,0)&" ft. "&FIXED(MOD(A3÷2.54,12),0)&" in"

Reply

Similar questions