Excel is turning entered dates into formulas despite format. Why?

[Matt Mahan]

I have a worksheet that turns all numbers with an operator into a formula.
For instance when I enter "4/11/06" it changes it to "=4/11/06". This is
regardless of what the cell format is, date, general, etc. I can create
another worksheet in this workbook and this does not occur. I can get around
this problem, but there is something tied to this particular sheet that
changes what is entered and I would like to find it.
Any help out there?

This is Excel 2003

[Peo Sjoblom]

Tools>options>transition uncheck transition formula entry, it is for
compatibility with Lotus 123


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"Matt Mahan" <Matt Mahan@discussions.microsoft.com> wrote in message
news:37AE78B9-0583-419D-B05E-A512963895FE@microsoft.com...
>I have a worksheet that turns all numbers with an operator into a formula.
> For instance when I enter "4/11/06" it changes it to "=4/11/06". This is
> regardless of what the cell format is, date, general, etc. I can create
> another worksheet in this workbook and this does not occur. I can get
> around
> this problem, but there is something tied to this particular sheet that
> changes what is entered and I would like to find it.
> Any help out there?
>
> This is Excel 2003