hit F4 when you have the cell range highlited, hit the key a couple
times until the $ signs are gone


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=519938