=A1*1000

and copy down

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Mother Goose" wrote in message
...
how do I multiply the values in column A by 1000, and put the results in
column B