a simple math formula
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
|