#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 55
Default converting to Kg

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10,124
Default converting to Kg

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default converting to Kg

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 268
Default Convert: Was converting to Kg


"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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default Convert: Was converting to Kg

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





  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default converting to Kg

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 524
Default converting to Kg

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default converting to Kg

.... 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Converting EST to PST neilalan Excel Worksheet Functions 4 April 19th 12 11:17 PM
Converting xls to ofx Vance Excel Discussion (Misc queries) 8 June 6th 10 01:25 PM
converting [email protected] Excel Discussion (Misc queries) 2 August 4th 06 11:44 PM
Converting .XLS to .XML [email protected] Excel Discussion (Misc queries) 6 October 14th 05 09:19 PM
converting assi New Users to Excel 1 June 15th 05 04:39 PM


All times are GMT +1. The time now is 03:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"