the function you would use is
=dollar(a1,0)
whereas a1 would be the top cell in the column. Then you copy a1,
highlight all the way to the last cell that you have data in- and
edit-fill down.
that should help you!
--
rae820
------------------------------------------------------------------------
rae820's Profile:
http://www.excelforum.com/member.php...o&userid=24135
View this thread:
http://www.excelforum.com/showthread...hreadid=377542