Date Formatting Converting to Decimal

[Bob Fasick]

Whenever I entered a date such as 4/15/2006 in a spreadsheet, Excel used to
recognize it as a date and display it as a date. Something has happened to
change that. Now when I enter 4/15/2006 in a spreadsheet, Excel enteres the
formula in the formula bar as =4/17/2006 and converts that to a very small
decimal by dividing 4 by 17 by 2006. If I apply a date format to the cell,
it displays the date as 1/0/1900. How can I get back to the old way where
Excel recognizes anything that closely resembles a date, and enters it as a
date? I am using Excel 2003

Thanks,

Bob Fasick

 

[Bob Phillips]

Check if the Transition navigation keys checkbox is set on
Tools>Options>Transition. If so, uncheck it.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Bob Phillips]

Sorry, I meant the Transition formula entry checkbox.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)