Author Message

Joined: 25 Sep 2007
Posts: 272

 Posted: Tue Jan 24, 2017 2:28 pm    Post subject: Quickly convert units in Excel – like Kg to pounds 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
 Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First
 All times are GMT + 2 Hours Page 1 of 1

 Jump to: Select a forum Forum Rules----------------General Rules Learn German Easily----------------German as a Foreign Language (Deutsch als Fremdsprache) Category----------------General ForumPolitics - commentsJokesScienceTechnology & How-To ForumEnvironmental Issues forumGeographic Information System (GIS) forumWebsites Related ForumPublic Health & Yoga forum Cappuccino & Espresso----------------Cappuccino & Espresso Job Posting----------------Job offerThe Space travellers
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