thanks!

"rae820" wrote:


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