Johnny,
in B1 put this formula =A1/10000 OK
Now double click on the little black square at the bottom right hand
corner of cell B1, or click and drag it down as far as you need to go.
If you have empty cells in column A you might like to change the
formula to
=IF(A1="","no data in column A",A1/10000)
HTH.
--
greg7468
------------------------------------------------------------------------
greg7468's Profile:
http://www.excelforum.com/member.php...fo&userid=9031
View this thread:
http://www.excelforum.com/showthread...hreadid=384810