Transfer Lbs into Kg.

[serge]

I'm looking for a formula that would transfer a number of Pounds ( Lb ) into Kilograms ( Kg ).

I have in F10: 253.6 Lbs and I would like in G10 in Kg.

What I did in G10 is this : =F10*45359237/1000

1 Lb is equal to : 453gr but to be more precise I did put the exact number gr. : 45359237.

and that give me : 11503103 but I would like the grams to be separate from the Kilo by a period ( . ) and only 2 digits after the period.

So the formula should give me this as result : 115.03 Kg

Thank you all for any help.
Serge.

 

[dave3009]

In G10 try

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

 

[Trebormac]

Serge,

Why not try a user defined function. Such as the following:

Public Function PoundsToKilograms(Pounds As Double) As Double
    PoundsToKilograms = Round(Pounds * 0.45359237, 2)
End Function

If your are not familar withh vba, reply back

Best,

Trebormac

 

[serge]

Dave,

I have 2 columns F in Lb and G in Kg.
I need to keep F the way it is I just need this G10 to do the conversion.

Thanks for the reply.

 

[serge]

Thanks Trebormac,

No I'm not familiar at all with VBA, that why I'm asking for a formula which is easier for me.

Thank you.

 

[Sandeep Warrier]

I have 2 columns F in Lb and G in Kg.
I need to keep F the way it is I just need this G10 to do the conversion.

If F is lb, then in G use the formula suggested by Dave. It will not change the value in F.

 

[bbr]

Hi,
In G10 put this formula = F10*453.59237/1000 and format F10 cell to two decimal points
bbr

 

[serge]

My bad, I miss understood, Thank you all for the help.
I really appreciate it.

Serge.

 

[serge]

Dave,

How do I stop at 2 digits after the period with your formula ? yours give me 3 digits after the period !

 

[Sandeep Warrier]

1. Format column G to number with two decimal places.

2. =ROUND(CONVERT(F10,"lbm","kg"),2)