Thanks, everyone.

I actually only needed to do the A column. I probably did not make that
clear. The suggestions were still helpful.

This works for just one column:

..Range("A5:A798").numberformat="000000"


--
DavidW
------------------------------------------------------------------------
DavidW's Profile: http://www.excelforum.com/member.php...o&userid=32630
View this thread: http://www.excelforum.com/showthread...hreadid=534117