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?
- Download this Unit Conversion Excel app.
- Save it in your local folder.
- Open the Excel file.
- Enable the macros & editing if requested.
- 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.
Download Unit Conversion Table in Excel Downloaded 397 Times
If the conversion does not happen automatically, then press the button “Convert”. To proceed with next conversion, then press “Clear” button & start over.
Excel Function – Engineering Unit Converter Xls
In Worksheet, we can use the function “=CONVERT (Number, Unit From, Unit To)” to do the Unit conversions.
- =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
For more unit names used in this function, refer this page from Microsoft. The same function is used in the Advanced Tab in the above Excel download.
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.
Engineering Unit Converter Download – Excel Table – Feet To Meters