Cyrus

You could format as ##-##-## but would not be a date, just a formatted number.

For quick-entry dates and times see Chip Pearson's site for VBA methods.

http://www.cpearson.com/excel/DateTimeEntry.htm


Gord Dibben MS Excel MVP

On Tue, 28 Feb 2006 11:36:25 -0800, "Cyrus"
wrote:

I want to type "121505" in a cell and it display 12-15-05. What formatting do
I use?

Thanks