Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Look in the help index for CONVERT.
-- Don Guillett SalesAid Software "Josh C" wrote in message ... 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 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Look at Excel help for the CONVERT() function.
-- David Biddulph "Josh C" wrote in message ... 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 |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... Look at Excel help for the CONVERT() function. -- David Biddulph "Josh C" wrote in message ... 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 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 |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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/ex...090221033.aspx -- David Biddulph "Bill Ridgeway" wrote in message ... 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! "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... Look at Excel help for the CONVERT() function. "Josh C" wrote in message ... 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 |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() |
#7
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Josh
Stick 2.204 into a cell. Copy that cell and select all other cells and EditPaste SpecialDivideOKEsc Gord Dibben MS Excel MVP On Mon, 21 May 2007 07:46:01 -0700, Josh C wrote: 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 |
#8
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ |
#9
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
.... or for greater accuracy
=A1 *0.45359237 -- David Biddulph "Stan Brown" wrote in message t... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Converting EST to PST | Excel Worksheet Functions | |||
Converting xls to ofx | Excel Discussion (Misc queries) | |||
converting | Excel Discussion (Misc queries) | |||
Converting .XLS to .XML | Excel Discussion (Misc queries) | |||
converting | New Users to Excel |