equal sign in front of date in formual bar

[Ron 130]

In an existing spreadsheet when I enter new dates in blank cells the tool bar
shows the date with an equal sign in front "=06Mar06" and the spreadsheet has
00Jan00. I have tried changing formating and coping from good date cells. I
even inserted a new column with the same results.

[Peo Sjoblom]

Do you have transition formula entry checked under tools>options>transition?
If so uncheck it

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"Ron 130" <Ron 130@discussions.microsoft.com> wrote in message
news:A8FCC3E8-A67C-4C62-A3F0-9BA36DC8E7DF@microsoft.com...
> In an existing spreadsheet when I enter new dates in blank cells the tool
> bar
> shows the date with an equal sign in front "=06Mar06" and the spreadsheet
> has
> 00Jan00. I have tried changing formating and coping from good date cells.
> I
> even inserted a new column with the same results.