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 Fasick" <xxxfasick@comcast.net> wrote in message
news:GIqdne6DorDktdzZnZ2dnUVZ_vSdnZ2d@comcast.com...
> 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]

Sorry, I meant the Transition formula entry checkbox.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Bob Fasick" <xxxfasick@comcast.net> wrote in message
news:GIqdne6DorDktdzZnZ2dnUVZ_vSdnZ2d@comcast.com...
> 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 Fasick]

Bob:

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

Regards,

Bob Fasick

"Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
news:uHhEgCLYGHA.4688@TK2MSFTNGP04.phx.gbl...
| Sorry, I meant the Transition formula entry checkbox.
|
| --
| HTH
|
| Bob Phillips
|
| (remove nothere from email address if mailing direct)
|
| "Bob Fasick" <xxxfasick@comcast.net> wrote in message
| news:GIqdne6DorDktdzZnZ2dnUVZ_vSdnZ2d@comcast.com...
| > 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
| >
| >
|
|