Quickly Convert Measurement Units in Excel 2007/2010

Without using formulas or functions, Kutools for Excel’s Unit Conversion feature makes it easy to convert values between common measurement units.Demo

Quickly convert one value from one measurement to another;
Quickly convert a range of data and overwrite the original value;
Quickly convert a range of data and insert into a new range as values.

Note: Unit Conversion supports the following types of units: Angle, Bits & Bytes, Distance, Energy, Force, Liquid, Mass, Surface, Temperature, Time and Volume.

Click "Kutools">>"Operation">>"Unit Conversion". See screenshots (Fig. 1).

Fig. 1： Unit Conversion

To convert a single value:

unit conversion--a single value

Fig. 2: Convert a Single Value dialogue box

Usage:

Select the Convert a Single Value tab;
Select an unit type from the Units category;
Choose the two units under the From list box and the To list box;
Enter a value in the Input box.

Notes:

The converted value will appear in the Converted value box, which will be updated automatically, whenever you change the input value or the unit type.
Conversion factor shows the conversion ratio between two units.

To convert a range of data:

Fig. 3： Convert a Range dialogue box

Usage:

Select the Convert a Range tab;
Select an unit type from the Units category;
Choose the two units under the From list box and the To list box;
Verify a range to be converted from the Source range; if you do not check the Overwrite source data, a new range has to be selected from the Results range for the converted values.
Click OK.

Notes:

If the Create conversion formulas option is checked, the result will be created in the form of formulas within the selected range.
You can press Undo (Ctrl+Z) to restore this operation immediately.

See Unit Conversion feature demo (video 1)

Video 1.Unit Conversion feature demo.