In the cell where you key in the date, goto FormatCellsCustom and set that
custom format.

--
HTH

Bob Phillips

"robertjtucker"
wrote in message
news:robertjtucker.1s60ad_1121353539.6635@excelfor um-nospam.com...

Can you explain a little


--
robertjtucker
------------------------------------------------------------------------
robertjtucker's Profile:
http://www.excelforum.com/member.php...o&userid=21805
View this thread: http://www.excelforum.com/showthread...hreadid=387126