Forum Index
shamskm.com Home
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Quickly convert units in Excel like Kg to pounds

 
Post new topic   Reply to topic     Forum Index -> Technology & How-To Forum
View previous topic :: View next topic  
Author Message
Admin
Site Admin


Joined: 25 Sep 2007
Posts: 272

PostPosted: Tue Jan 24, 2017 2:28 pm    Post subject: Quickly convert units in Excel like Kg to pounds Reply with quote

The following table lists weight of several persons in kilogram. I would like to convert them into pounds.

Select cell C2 > click on fx

(you find it ( fx ) left to the formula bar or under the Formulas tab it's called 'Insert Function')


The 'Insert Function' window opens > from under Select a function > select CONVERT > click OK or double-click on it.


The 'Function Arguments' window opens.





Here under Number > select or type cell B2 or type any number manually.

From_unit type kg

To_unit type lbm

Click OK.


Now the result is displayed in cell C2. Copy the formula down the column.





By the way, I have formatted the Column C to get decimlas upto 2 places.



Alternatively, you could type in cell C2 the CONVERT function exactly the way you see it in the above images [=CONVERT(B2;"kg";"lbm")] or [=CONVERT(96;"kg";"lbm")], then copying it for the rest of the cells.




Common unit symbols for Excel

Gram - "g"

Kilogram - "kg"

Pound mass - "lbm"


Meter - "m"

Inch - "in"

Foot - "ft"

Yard - "yd"


Year - "yr"

Day - "day" or "d"

Hour - "hr"

Minute - "mn" or "min"

Second - "sec" or "s"


Liter - "l" or "L" ("lt")

Gallon - "gal"



For more unit symbols, check this page from Microsoft





*Recommended:

Read wonderful articles (English & German) on Science & Tech, Environment, Health and many other topics only on BlogArena.

For comments of suggestions, please contact us: info@shamskm.com
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic   Reply to topic     Forum Index -> Technology & How-To Forum All times are GMT + 2 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group