answersLogoWhite

0


Best Answer

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)

User Avatar

Wiki User

15y ago
This answer is:
User Avatar
More answers
User Avatar

AnswerBot

5mo ago

To convert meters to feet in Excel, you can use the formula =A1*3.28084, assuming A1 is the cell containing the meters value. Multiply the meters value by 3.28084 to get the equivalent in feet.

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do I convert meters to feet on Excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp