Convert in Excel

Convert in Excel

This function converts a value measure in one type of unit, to the same value expressed in a different type of unit, such as Inches to Centimeters.

Microsoft Excel Function

=CONVERT(AmountToConvert,UnitToConvertFrom,UnitToConvertTo)                    

                                     

Formatting                                                                                                          

No special formatting is needed

Content Data

Amount To Convert	Converting From	Converting To	Converted Amount
2	in	cm	5.08	=CONVERT(C4,D4,E4)
1	ft	m	0.3048	=CONVERT(C5,D5,E5)
3	yd	m	2.7432	=CONVERT(C6,D6,E6)
2	yr	day	730.5	=CONVERT(C8,D8,E8)
1	day	hr	24	=CONVERT(C9,D9,E9)
2	hr	mn	120	=CONVERT(C10,D10,E10)
3	mn	sec	180	=CONVERT(C11,D11,E11)

Example

The following table was used by an Import / Exporting company to convert the weight                                                   

and size of packages from old style UK measuring system to European system.

         

	Pounds	Ounces	Kilograms
Weight	5	3	2.3530101
			=CONVERT(D28,"lbm","kg")+CONVERT(E28,"ozm","kg")

              

                                                         

	Feet	Inches	Metres
Height	12	6	3.81
Length	8	3	2.5146
Width	5	2	1.5748
			=CONVERT(D34,"ft","m")+CONVERT(E34,"in","m")

         

Conversion symbols and meaning

Weight & Mass			Distance
Gram	g		Meter	m
Kilogram	kg		Statute mile	mi
Slug	sg		Nautical mile	Nmi
Pound mass	lbm		Inch	in
U (atomic mass)	u		Foot	ft
Ounce mass	ozm		Yard	yd
			Angstrom	ang
Time			Pica (1/72 in.)	Pica
Year	yr
Day	day		Pressure
Hour	hr		Pascal	Pa
Minute	mn		Atmosphere	atm
Second	sec		mm of Mercury	mmHg
Temperature			Liquid
Degree Celsius	C		Teaspoon	tsp
Degree Fahrenheit	F		Tablespoon	tbs
Degree Kelvin	K		Fluid ounce	oz
			Cup	cup
Force			Pint	pt
Newton	N		Quart	qt
Dyne	dyn		Gallon	gal
Pound force	lbf		Liter	l
Energy			Power
Joule	J		Horsepower	HP
Erg	e		Watt	W
Thermodynamic calorie	c
IT calorie	cal		Magnetism
Electron volt	eV		Tesla	T
Horsepower-hour	HPh		Gauss	ga
Watt-hour	Wh
Foot-pound	flb
BTU	BTU

Prefix	Multiplier	Abbreviation		Prefix	Multiplier	Abbreviation
exa	1.00E+18	E		deci	1.00E-01	d
peta	1.00E+15	P		centi	1.00E-02	c
tera	1.00E+12	T		milli	1.00E-03	m
giga	1.00E+09	G		micro	1.00E-06	u
mega	1.00E+06	M		nano	1.00E-09	n
kilo	1.00E+03	k		pico	1.00E-12	p
hecto	1.00E+02	h		femto	1.00E-15	f
dekao	1.00E+01	e		atto	1.00E-18	a