Kilograms

justine · Feb 19th, 2002, 03:07 PM

I have 2 cells. D2 is where I will enter the pounds in. I want D1 to change the pounds into Kilograms. How do I do this?

Chris Davison · Feb 19th, 2002, 08:12 PM

there's 2.204623 pounds in a kilo, so in cell D1 just enter =D2/2.204623

if you want to show "kgs" after the number also, try =TEXT((D2/2.204623),"#,###.000")&" kgs" where the amount of 0s are however many decimals you want

Chris Davison · Feb 19th, 2002, 08:16 PM

oooops, I see this has already been answered earlier - can this entry be deleted ?

Mark W. · Feb 21st, 2002, 11:32 AM

Justine, you could also employ the CONVERT function which is made available with the installation of the Analysis ToolPak...

=CONVERT(D2,"lbm","kg")

If you'll consult the Help topic for CONVERT you'll see it's quite useful when you don't know the conversion factors or want greater precision than you can recall.

Feb 19th, 2002, 08:12 PM	#2
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	there's 2.204623 pounds in a kilo, so in cell D1 just enter =D2/2.204623 if you want to show "kgs" after the number also, try =TEXT((D2/2.204623),"#,###.000")&" kgs" where the amount of 0s are however many decimals you want __________________ :: Pharma Z - Family drugstore ::

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 19th, 2002, 03:07 PM	#1
justine New Member Join Date: Feb 2002 Posts: 27	I have 2 cells. D2 is where I will enter the pounds in. I want D1 to change the pounds into Kilograms. How do I do this?

Feb 19th, 2002, 08:16 PM	#3
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	oooops, I see this has already been answered earlier - can this entry be deleted ?

Feb 21st, 2002, 11:32 AM	#4
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Justine, you could also employ the CONVERT function which is made available with the installation of the Analysis ToolPak... =CONVERT(D2,"lbm","kg") If you'll consult the Help topic for CONVERT you'll see it's quite useful when you don't know the conversion factors or want greater precision than you can recall.