Range("B9:F33").NumberFormat = "m/d/yyyy"

--
Regards,
Tom Ogilvy

"turnerje" wrote in
message ...

I would like to use VBA to have excel select a specific range, and then
format it for a specific date format (3/14/2005). I am running Office
2003. Many thanks in advance.

Justin


--
turnerje
------------------------------------------------------------------------
turnerje's Profile:
http://www.excelforum.com/member.php...o&userid=25694
View this thread: http://www.excelforum.com/showthread...hreadid=472088