converting to Kg

[Guest]

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

 

[Don Guillett]

Look in the help index for CONVERT.

 

[David Biddulph]

Look at Excel help for the CONVERT() function.

 

[Bill Ridgeway]

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

 

[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

 

[Don Guillett]

Then just use a formula

 

[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

 

[Stan Brown]

Mon, 21 May 2007 07:46:01 -0700 from 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

=A1/2.2

or for greater accuracy

=A1*0.454

 

[David Biddulph]

.... or for greater accuracy
=A1 *0.45359237