You sure you put the code in the correct spot--under the worksheet?

See Tom's instructions one more time.

But make one minor adjustment:

change this:
Range("B5").NumberFormat:="mm/dd/yyyy"
to
Range("B5").NumberFormat = "mm/dd/yyyy"

(drop the colon near the equal sign)

ceemo wrote:

this doesnt actually work

has anyone got any ideas on how to fix this?

--
ceemo
------------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=571820

--

Dave Peterson