• ## Engineering Unit Conversion Table In Excel

This Engineering Unit Converter Excel app can perform below listed conversions.

• Length: meter, centimeter, millimeter, kilometer, mile, yard, feet, inch
• Weight: gram, kilogram,ounce,ton,pound,stone
• Volume: liter, ounce, gallon

Units that correspond to Length, Weight & Volume can be converted with this free app. In addition, it also has a Unit Conversion Table within it. This table provides measurements to the lowest unit & how to use the built in Excel formula ‘=Convert’.

Note: If it is just simple ‘feet to meters’ or ‘1 mile in feet’ , then just use the quick Excel function explained at end of page.

## Feet to Meters – Mile in Feet – Convert Units Any to Any

The Excel sheet in this app is divided into three segments. One for each Measurement Segment.This app does not use the built in function. Instead it uses numeric calculations defined within the Excel VBA code.

How to Use this App?

2. Save it in your local folder.
3. Open the Excel file.
4. Enable the macros & editing if requested.
5. Enter Units to be converted & Click “Convert’ button.

Enter the measured number to be converted in column 2 against any unit. Then Excel will automatically calculate the corresponding units & display in adjacent table.

If the conversion does not happen automatically, then press the button “Convert”. To proceed with next conversion, then press “Clear” button & start over.

Also Read: Excel VBA - Find String in Range - Return Row - Change Background Color - Remove Duplicates

## Excel Function – Engineering Unit Converter Xls

In Worksheet, we can use the function “=CONVERT (Number, Unit From, Unit To)” to do the Unit conversions.

Examples:

• =convert(1,m,cm) <-1 meter to cms = 100 units
• =convert(1,mi,ft) <- 1 mile in feet is 5280 units
• =convert(1,ft,m) <- 1 feet to meters is 0.3048 Units

Thanks to Hossein Satour for suggesting this function name in comments section.

## Excel Unit Conversion – Additional References

These days, Google itself will do its conversion directly from its search results page. If there is too much of unit conversion needed within your automation, then use the functions explained in this page.

If you have other conversion to be included with this app, leave it in the comments. Provide units & its conversion table that would benefit the readers.

Author: Kumarapush

Kumarapush has experience in IT industry for 12+ Years including 10 Years in MNC. Has vast expertise in Microsoft Excel automation using VBA Macro. Excel to CSV converter is one of his famous tool that has been downloaded & used by 68,000 users around the globe.

Previous Post:
Next Post:

• Hossein SATOUR

thank you, but there are some mistakes. for example 1cm = 100mm!! or 1m = 10cm !!
we can also use the Excel function CONVERT() which has a many unit conversion.
Have a nice day

• https://officetricks.com/ kumarapush

Thank You Hossein for your valuable comment. I have corrected the page and Excel as per your suggestions. 🙂