I'm using Excel 2002. When I type a date, it changes the cell to the
formula and it changes what I typed to something else.

Example:

I type "8/25/2006" without the quotes. I hit enter and it changes to
"=8/25/2006" in the forumla bar. But the cell displays "1/0/1900".

I'm sure there is a setting causing this. Can someone help me?

Thanks,
Paul

Select Date Format

mama no teeth

"PCLIVE" wrote:

I'm using Excel 2002. When I type a date, it changes the cell to the
formula and it changes what I typed to something else.

Example:

I type "8/25/2006" without the quotes. I hit enter and it changes to
"=8/25/2006" in the forumla bar. But the cell displays "1/0/1900".

I'm sure there is a setting causing this. Can someone help me?

Thanks,
Paul

Try:

tools|Options|Transition tab|Uncheck Transition formula entry

In fact, I'd suggest unchecking all those Lotus 123 settings on that dialog.

PCLIVE wrote:

I'm using Excel 2002. When I type a date, it changes the cell to the
formula and it changes what I typed to something else.

Example:

I type "8/25/2006" without the quotes. I hit enter and it changes to
"=8/25/2006" in the forumla bar. But the cell displays "1/0/1900".

I'm sure there is a setting causing this. Can someone help me?

Thanks,
Paul

--

Dave Peterson

Thanks Dave,

That worked now that someone told me to do that. But the funny thing is, I
only just checked that option in my attempt to fix this issue. But now that
I uncheck it, it works again. Weird. Anyway, it works now.

Thanks again,
Paul

"Dave Peterson" wrote in message
...
Try:

tools|Options|Transition tab|Uncheck Transition formula entry

In fact, I'd suggest unchecking all those Lotus 123 settings on that
dialog.

PCLIVE wrote:

I'm using Excel 2002. When I type a date, it changes the cell to the
formula and it changes what I typed to something else.

Example:

I type "8/25/2006" without the quotes. I hit enter and it changes to
"=8/25/2006" in the forumla bar. But the cell displays "1/0/1900".

I'm sure there is a setting causing this. Can someone help me?

Thanks,
Paul

--

Dave Peterson

Go into ToolsOptionsTransition and uncheck the Lotus options like

Transition formula evaluation and Transition formula entry.


Gord Dibben MS Excel MVP


On Sun, 3 Sep 2006 11:29:32 -0400, "PCLIVE" <pclive(remove wrote:

I'm using Excel 2002. When I type a date, it changes the cell to the
formula and it changes what I typed to something else.

Example:

I type "8/25/2006" without the quotes. I hit enter and it changes to
"=8/25/2006" in the forumla bar. But the cell displays "1/0/1900".

I'm sure there is a setting causing this. Can someone help me?

Thanks,
Paul