Quickly convert units in Excel – like Kg to pounds

Forum to talk about all the latest technologies - ins and outs!!
Post Reply
Admin
Site Admin
Posts: 286
Joined: Tue Sep 25, 2007 12:41 pm

Quickly convert units in Excel – like Kg to pounds

Post by Admin » Tue Jan 24, 2017 2:28 pm

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.


Image


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.


Image


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

Whinding
Posts: 1
Joined: Mon Dec 17, 2018 1:15 pm

Technology & How-To Forum

Post by Whinding » Mon Dec 17, 2018 2:05 pm

We all know that MS excel is one of best feature of Microsoft office which is responsible for data storage and conversion of any data to the essay writer.Some of the formulas are available in Excel for data handling.

Post Reply