Martin, first, thanks for taking the time to respond.

1. Thanks for mentioning the shortened form .... =B5*2.2. ( or
=B5*2.20462262 )

2. Thanks for the more accurate conversion number.

3. Your comment re the use of In C5 enter =CONVERT(B5,"kg","lbm"), I must
have not copied that formula correctly. Just now I went back and tried it
and of course it works.

Guys, thanks for bearing with me on this. Dave Horne







"MartinW" wrote in message
...
Hi Dave,

You've led yourself astray here on a few counts.

1) No need to use =SUM(B5)*2.2, just =B5*2.2 will do fine

2) 2.2 is not the correct conversion factor, it should be 2.20462262

3) If you simply used Roger's original formula you wouldn't
need to bother with the correct conversion factor.

HTH
Martin


"Dave Horne" wrote in message
...

I came up with =SUM(B5)*2.2 which works for converting B5 to C5.

I almost posted too soon with the following, but I saw by dragging the
black box in the right corner (of C5), the simple math equation is now
applied to every B cell.

It's been a while but I at least solved this simple task.

Thanks, Dave Horne



"Roger Govier" <roger@technology4unospamdotcodotuk wrote in message
...
Hi David

In C5 enter
=CONVERT(B5,"kg","lbm")
and copy down through C6:C77

--
Regards
Roger Govier

"Dave Horne" wrote in message
...
Hi, I'm new to this and have a very simple question.

I have values, simple numbers representing weight in kg, that I wish to
automatically convert to US pounds.

The 'kg' numbers are in fields B5 - to B77 for example. I want the
conversion result (simply multiplying each B cell entry by 2.2) placed
in the ''cell adjacent. Thanks! Dave Horne