# Converting Meters to Feet in Excel

Learn how to convert meters to feet in Excel with a simple formula, plus a feet and inches version and the CONVERT function for your event sheets.

Converting meters to feet in Excel means multiplying the meter value by 3.28084, the number of feet in one meter. You can place that Excel conversion formula in a cell beside your measurement column and copy it down a whole list of distances. A second formula splits the result into feet and inches for readable event sheets, and the CONVERT function does the same job in one step. 

## Multiply by 3.28084 for decimal feet 

The direct conversion uses one multiplication, because one meter equals 3.28084 feet. If a distance sits in cell A2, the formula =A2*3.28084 returns that length in decimal feet. Fill the formula down a spreadsheet measurement column so every row converts with the same factor. Format the result with two decimals to keep the sheet tidy for race lengths or field sizes. 

## Split the result into feet and inches 

A decimal foot value is awkward to read, so a feet and inches formula separates the whole feet from the leftover inches. Multiplying the decimal part by twelve gives the inches, and the INT function takes the whole feet. The ROUND function keeps the inches to a workable precision for marking a course. Some conversions also carry a stock label for feet and inches, which is worth checking on a tape measure. 

## Use CONVERT for a clean sheet 

The CONVERT function changes a value from one unit to another when you name both units in the formula. Writing =CONVERT(A2,"m","ft") returns the same figure as the multiplication and keeps the sheet self-explanatory. CONVERT accepts unit names such as m for meters and ft for feet for length. A reader who opens the spreadsheet later can see the source unit without hunting for a hidden factor. 

## Questions About Meters to Feet in Excel 

### How do I convert meters to feet in Excel? 

You convert meters to feet in Excel by multiplying the cell by 3.28084. If the meter value sits in A2, type =A2*3.28084 into the next cell and press Enter. Copy the formula down the column to convert a whole list of event distances. The result is a decimal number of feet you can format as you like. 

### How do I convert meters to feet and inches in Excel? 

You get feet and inches in Excel by building the feet part and the inches part in one formula. Use INT(A2*3.28084) for whole feet, then multiply the decimal remainder by twelve and round it for inches. Combining both parts with the ampersand and quote marks gives a text label such as 5 ft 6 in. Keep the original number in its own cell so the label never blocks later calculations. 

### What is the CONVERT function for meters and feet? 

The CONVERT function is Excel's built-in unit changer, and it needs the value plus the from and to unit names. The formula =CONVERT(A2,"m","ft") converts meters to feet without a remembered factor. Unit names are case sensitive in CONVERT, so type m and ft exactly. It reads clearly to anyone who opens the spreadsheet. 

### Can I use one conversion formula for a whole column? 

Yes, one formula can fill an entire spreadsheet measurement column. Write the formula once against the first meter value, then drag the fill handle down or copy and paste it over the other rows. Relative cell references shift with each row, so every distance converts correctly. Lock the factor in its own cell with absolute references if you plan to change it later.
