equal sign in front of date in formual bar  
Author Message
Pookie76





PostPosted: Wed Apr 05 16:23:39 CDT 2006 Top

worksheet functions >> equal sign in front of date in formual bar

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.

Excel373  
 
 
Peo





PostPosted: Wed Apr 05 16:23:39 CDT 2006 Top

worksheet functions >> equal sign in front of date in formual bar Do you have transition formula entry checked under tools>options>transition?
If so uncheck it

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.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.