J
Josh C
i have a program that is in pounds. i has wondering if there is an easy way
to convert the majority of the program to kilograms
to convert the majority of the program to kilograms
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Don Guillett
Look in the help index for CONVERT.
D
David Biddulph
Look at Excel help for the CONVERT() function.
B
Bill Ridgeway
David Biddulph said:Look at Excel help for the CONVERT() function.
Thanks David for pointing out CONVERT. I hadn't noticed it before. Just
one word of warning when converting liquid measure. The unit gallons seem
to be US gallons NOT UK gallons. Another one to watch is Tons (UK & US).
There may be other imperial units that will return an unexpected answer!
Regards.
Bill Ridgeway
Computer Solutions
D
David Biddulph
That's interesting, Bill.
My version doesn't have tons, from either side of the pond. My version
distinguishes between US & UK for pints, but not for gallons.
http://office.microsoft.com/en-us/excel/HP052090221033.aspx
My version doesn't have tons, from either side of the pond. My version
distinguishes between US & UK for pints, but not for gallons.
http://office.microsoft.com/en-us/excel/HP052090221033.aspx
D
Don Guillett
Then just use a formula
G
Gord Dibben
Josh
Stick 2.204 into a cell.
Copy that cell and select all other cells and Edit>Paste Special>Divide>OK>Esc
Gord Dibben MS Excel MVP
Stick 2.204 into a cell.
Copy that cell and select all other cells and Edit>Paste Special>Divide>OK>Esc
Gord Dibben MS Excel MVP
S
Stan Brown
Mon, 21 May 2007 07:46:01 -0700 from Josh C
=A1/2.2
or for greater accuracy
=A1*0.454
i have a program that is in pounds. i has wondering if there is an easy way
to convert the majority of the program to kilograms
=A1/2.2
or for greater accuracy
=A1*0.454
D
David Biddulph
.... or for greater accuracy
=A1 *0.45359237
=A1 *0.45359237