How do I convert meters to feet on Excel?

Answer 1

1 metre = 3.2808399 feet. So what you have to do is multiply the metres by 3.2808399. So say you have your amount of metres in cell B2. In an empty cell you would put the formula:

=B2*3.2808399

Open the Microsoft Excel program.

Install the Convert function if it is not already installed. The Convert function is not installed by default. It is part of the "Analysis Add-in" tool pack. To install add-ins, click on the "Tools" menu, and click on "Add-ins

Put a checkmark beside "Analysis Toolpak".

Use the Convert function. You enter the formula by typing CONVERT(x,"y","z"), where "y" is the original unit of measurement, "x" is the quantity of that unit, and "z" is the unit of measurement you want to convert to. Note that there are no spaces in the command, and the commas and quotation marks are necessary.

Examine this example. Suppose we wanted to convert 60 miles to kilometers:

Type =CONVERT(60,"mi","km"). You should get 96.56064. You may get another number that is close to that, depending on how many significant digits your spreadsheet is set to display.

A complete listing of measurement units that the Convertfunction supports is available from Microsoft Office Online. (http://office.microsoft.com/en-us/excel/HP052090221033.aspx)