|Why do some cells default back to text when the date is typed in, even when the cell is formatted as a date?|
Dates require the slash character to be used
for Excel to recognize them as correct Dates.
If you have a cell that has NOT been formatted as a Date but left
as the default General format and enter 030313,
your going to end up with the number 30313.
If you have a cell that has been formatted as TEXT and enter 030313
you end up the the Text String 030313
If you have a cell that HAS been formatted as a Date and enter
030313, your going to end up with the Date 12/28/1982.
That's because Excel stores dates as a number
representing the number of days since 01/01/1900.
With out the Slash, Excel converted 030313,
to 30313, (dropped the leading zero)
then converted that to the number of days since 01/01/1900
and came up with 12/28/1982
Even if the cell is formatted as a Date, use the Slash when
entering the date.