equal sign in front of date in formual bar

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
How do i enter the date in column instead of # sign? 2
Adding days to a date - changed in Excel 2010 8
equal sign in function bar 3
Display date in spanish 3
Can't Stop Date Values from Changing to Formulas 2
Formula bar doesn't have an equal sign 1
Autofill date on date entry in a separate column 2

Top