I was wondering if there was a formula to convert a number that is in pounds
(i.e. weight pound) into kilos. For example, I have the number 4419lb and
would like the column next to it to convert the number to kilos
automatically. I tried the formula using CONVERT, but it does not accept the
cell name. Any other ideas? We are working in Excel 2000.

you can't have "lb" in the cell, it has to be simply a number

"Janet" wrote:

I was wondering if there was a formula to convert a number that is in pounds
(i.e. weight pound) into kilos. For example, I have the number 4419lb and
would like the column next to it to convert the number to kilos
automatically. I tried the formula using CONVERT, but it does not accept the
cell name. Any other ideas? We are working in Excel 2000.

With the number of lbs. in A1, use:

=CONVERT(A1,"lbm","g")/1000

HTH
Jason
Atlanta, GA

-----Original Message-----
I was wondering if there was a formula to convert a
number that is in pounds
(i.e. weight pound) into kilos. For example, I have the
number 4419lb and
would like the column next to it to convert the number
to kilos
automatically. I tried the formula using CONVERT, but it
does not accept the
cell name. Any other ideas? We are working in Excel 2000.
.

True, unless it's a number, with a number format code (Format - Cells -
Number - Custom): like:
General "lb"

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Gate" wrote in message
...
you can't have "lb" in the cell, it has to be simply a number

"Janet" wrote:

I was wondering if there was a formula to convert a number that is in
pounds
(i.e. weight pound) into kilos. For example, I have the number 4419lb and
would like the column next to it to convert the number to kilos
automatically. I tried the formula using CONVERT, but it does not accept
the
cell name. Any other ideas? We are working in Excel 2000.