How can I convert feet to meters using Numbers

Convert m to in, QUOTIENT will give you the number of feet, MOD will provide the number of inches left over, truncated to the last full inch.

If you want the result rounded to the nearer full inch, round the result of the initial conversion. If you need fractions of inches (ludicrous if the original figure is to the nearest metre), that can be done as well.

m in B2,

formula in C2: =ROUND(B2*39.3700787,0) (inches, rounded to nearer full inch)

formula in D2: =QUOTIENT(ROUND(B2*39.3700787,0),12)&" Ft. "&MOD(ROUND(B2*39.3700787,0),12)&" In."

Regards,

Barry

There are several unit conversion calculators online, easily found with a search of 'xxx to yyy' with xxx and yyy replaced by the units you wish to convert from and to.

If you really want to use Number for the conversion the formula below, placed in C2 will give the number of metres (accurate to 4 places) of the number of feet, placed in B2:

=B2*0.3048

Regards,

Barry

Romc,

This expression will convert meters to feet and inches. You didn't specify how you want it presented, so there could be variations on this. for meters in column A:

=INT(A*39.36/12)&"-Ft "&A*39.36-INT(A*39.36/12)*12&"-In"

For a value of 1.0 in A, the expression will return:

3-Ft 3.36-In

Regards,

Jerry

Try Google.

in a google search type "1 ft to m"