Format date to put in / or -

DKR · Sep 15, 2005

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.

Chip Pearson · Sep 15, 2005

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