Date Format Behavior

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In an Excel 2000 workbook, when the date "5/13/05" is entered in a cell, upon
leaving the cell the date changes to "5/13/2004."

The computer date is set to the correct year. The Excel Date format is set
for the appropriate format.

Any ideas on what can cause this strange behavior?

Thanks,
Craig.
 
Do you have any event macros running?

What do you see in the cell when you format it as General?
 
You must log in or register to reply here.

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

Calculating interest due on late loan payments 1
Date 2
Trouble With Text Input 2
Remove date format? 3
DATES ARE SCRAMBLED! 9
Date Format 4
Change date format 0
Sort imported date column 7

Back
Top