Unit Conversion Table In Excel
Download the Free Excel Unit Convertion available at end of this page to perform simple conversion of basic measurements.
Units that correspond to Length, Weight & Volume can be converted with this free app. Also it has a Conversion Table within it, providing measurements to the lowest unit. The following conversions are possible with this Excel Sheet VBA App.
- Length: meter, centimeter, millimeter, kilometer, mile, yard, feet, inch
- Weight: gram, kilogram,ounce,ton,pound,stone
- Volume: liter, ounce, gallon
How to use this Simple Unit Conversion Tool?
The Excel sheet in this app is divided into three segments for the different measurements as mentioned above. Download this app, save it in your local folder. Open the Excel file and enable the macros. Enter the measured number to be converted in column 2 against any unit.
Download Unit Conversion Excel Sheet Downloaded 195 Times
Then Excel will automatically calculate the corresponding units & display in adjacent table with converted units. If the conversion does not happen automatically, then press the button “Convert”. If you want to proceed with next conversion, then press “Clear” button and proceed as explained from first.
Excel Function To Convert Units
Thanks to Hossein Satour for suggesting this function name in comments section. In Worksheet, we can use the function “=CONVERT (Number, Unit From, Unit To)” to do the Unit conversions.
For Example: =convert(1,m,cm) <-this will result in 100.
Similarly for the Unit names that can be used in this function, refer this page from Microsoft. The same function is used in the Advanced Tab in the above Excel download.
If you have other conversion to be included with this app, please provide the unit and its conversion table in the comments section that would benefit the readers.
Engineering Unit Converter Download