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.