Dates are stored as serial numbers. The serial number for February 2nd, 2229
is the number 120199. 120199 represents the number of days from 1/0/1900
(1/1/1900 equals 1). Enter your dates with hyphens "-" or slashes "/". For
more information look in the help under "enter a date", and "How Microsoft
Excel stores dates and times".

"Gracie" wrote:

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.