Auto formula when putting in date

[scott]

I have a workbook where, when I enter a date such as
11/30, Excel automatically puts an = in front of it,
yielding a value I don't want. I have several sheets in
the workbook and they all do the same thing. The only way
I can get the cell to look like a date is to put a "'" in
front of it and then it doesn't act like a date (i.e., I
can't use it in a different formula to compare the date).

Other workbooks will automatically format the cell as a
date and do not put the = sign in front. I can put a date
in the other workbook, paste it into the cell in the first
workbook, and it retains the date format and behaves like
a date. As soon as I edit the cell (i.e., enter another
date such as 11/30), it puts the = sign in front.

 

[Peo Sjoblom]

Look under tools>options>transition and uncheck transition formula entry

 

[Scott]

That did the trick. Thanks alot.

-----Original Message-----
Look under tools>options>transition and uncheck transition formula entry

--

Regards,

Peo Sjoblom




.