Gracie

You need to put in the slashes when you input a date:

12/01/99

If you input something that Excel recognises as a date, it will format the
cell automatically, although it might not be exactly what you want.

Regards

Trevor


"Gracie" wrote in message
...
I selected a cell to be formatted as a date (MS example 03/14/01)

When I key 120199 in that cell it displays in as 02/02/29......Why?
I even went into the Control Panel then Regional Settings for Date.