You can't do it with formatting. You need VBA code. See
http://www.cpearson.com/excel/datetimeentry.htm .

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"DKR" wrote in message
...
Can you format a cell so that you can just put in 091505 and it
will enter it
as 09/15/05. Sure would save me some time.