View Single Post
  #3   Report Post  
Jason Morin
 
Posts: n/a
Default

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.
.