How to Convert Feet to Meters in Excel (4 Simple Methods)

In Excel calculations, users often need unit conversions to fit their data depending on their customers. Therefore, users trying to convert feet to meters in Excel is pretty common. Users can use Arithmetic Operations, CONVERT, or TRUNC function, as well as the Paste Special feature, to convert feet to meters.

Let’s say we have a dataset that contains students’ basic information such as IDs, Names, and Height in feet. We want to convert the Height in feet to Height in meters.

Dataset-Convert Feet to Meters in Excel

In this article, we describe methods such as Arithmetic Operations, CONVERT, or TRUNC function, and Paste Special feature to convert feet to meters in Excel.


Download Excel Workbook


4 Easy Methods to Convert Feet to Meters in Excel

Follow any of the below-described methods to convert feet to meters in Excel.


Method 1: Converting Feet to Meters Using Arithmetic Operations

Arithmetic Operations such as Multiplication (i.e., x) or Division (i.e., /) are the basic tool to go with in converting feet to meters. Converting feet to meters manually requires a Conversion Operator. For multiplication, the Conversion Operator is 0.3048 and for division, it’s 3.28.

Step 1: In an adjacent cell use the Multiplication (in this case used here) or the Division Conversion Operator with the feet values.

=D5*0.3048

 Or

=D5/3.28

Arithmetic Operations-Convert Feet to Meters in Excel

Step 2: Press ENTER then drag the Fill Handle to convert all the foot entries into meters as shown below.

Fill Handle

🔺 You can use the Division Conversion Operator instead of the Multiplication. In both cases, the outcomes remain the same.

Multiplication and Division OperatorsRead More: How to Convert Meters to Feet in Excel (4 Useful Methods)


Method 2: Using CONVERT Function to Convert Feet to Meters

Excel offers the CONVERT function that converts given cell values from a specified unit to another specified unit. The syntax of the function is

CONVERT (number, from_unit, to_unit)

Here, in the arguments,

number; the numeric value you want to convert.

from_unit; numeric values’ existing unit.

to_unit; numeric values unit you want them into.

Step 1: Paste the following formula in any blank cell (i.e., E5).

=CONVERT(D5,"ft","m")

In the formula,

D5 = number

“ft” = from_unit

“m” = to_unit

CONVERT Function-Convert Feet to Meters in Excel

Step 2: Use the ENTER key to execute the function afterward drag the Fill Handle to apply it to the entire range.

CONVERT Function OutcomeRead More: How to Convert Square Feet to Square Meters in Excel (2 Quick Methods)


Similar Readings


Method 3: Feet to Meters Conversion Using Excel Paste Special Feature

Excel’s Paste Special feature offers multiple options including Multiply and Divide. Users can use these operations to multiple or divide cell values with respective Conversion Operators. As we mention earlier, 0.3048 and 3.28 are the Multiplication and Division Conversion Operators respectively.

Step 1: Type one of the Conversion Operators Multiplication (i.e., 0.3048) or Division (i.e., 3.28) as depicted in the below image.

Paste Special-Convert Feet to Meters in Excel

Step 2: Copy (CTRL+C) the Conversion Operator cell (i.e., D4) then highlight the entire value cells.

Copy then highlight

Step 3: Right-click on any highlighted cells. The Context Menu appears. Choose Paste Special > Again click on Paste Special (situated at the bottom of the 2nd window).

Paste Special option

Step 4: The Paste Special window appears. Mark Multiply (in this case) or Divide. Make Sure the All option is marked under the Paste section. Then click OK.

Paste Special window

Step 5: Excel takes a moment, all the entries in feet get converted into meters as shown in the below picture.

Outcome

In case, you want to use the Divide option in the Paste Special window, use the Division Conversion Operator in cell D4.

Read More: How to Convert Feet to Inches in Excel (4 Quick Methods)


Method 4: Using TRUNC Function to Convert Feet to Meters

The TRUNC function usually is not used to convert values, it returns the truncated values up to an optional decimal point. However, Excel users can use this function to execute the conversion. The syntax of the function is

TRUNC (number, [num_digits])

Step 1: Use the below formula in cell E5.

=TRUNC(D5*12*2.54)/100

The formula takes D5 as a number and then converts it into centimeters. 1 foot = 12 inch afterward 1 inch = 2.54 centimeter. That’s how D5 gets converted into centimeters. At last, dividing the value by 100 results in meter.

TRUNC Function-Convert Feet to Meters in Excel

 Step 2: Hit ENTER then drag the Fill Handle to apply the formula in other cells.

TRUNC Function OutcomeRead More: Convert Cubic Feet to Cubic Meters in Excel (2 Easy Methods)


Conclusion

In this article, we demonstrate the available methods to convert feet to meters in Excel. Use any of the methods to convert your units. Hope this article clarifies your understanding regarding feet to meters conversion. Comment, if you have further inquiries or have anything to add.


Related Articles

Maruf Islam

Maruf Islam

My self, Maruf Islam, an engineer and Excel & VBA Content developer on Exceldemy. I enjoy solving problems, finding workable solutions, and most of the part I really like to take on challenges. On Exceldemy I write articles discussing various way outs of Microsoft Excel's stuck ons.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo