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)

 

[Bob Fasick]

Bob:

That was easy! Many thanks. I would have never figured that out. I
appreciate your help

Regards,

Bob Fasick

| Sorry, I meant the Transition formula entry checkbox.
|
| --
| HTH
|
| Bob Phillips
|
| (remove nothere from email address if mailing direct)
|
| | > 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
| >
| >
|
|