"Hemming" wrote in
message ...

can this be used in a macro ?????
It could be, but, for changing the values in a single column, it's simplest
and quickest just to write a formula (using relative cell addressing),
format it properly, and copy it down all the rows.

HTH,

Don



--
Hemming
------------------------------------------------------------------------
Hemming's Profile:
http://www.excelforum.com/member.php...o&userid=32185
View this thread: http://www.excelforum.com/showthread...hreadid=519308