Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Date Format Behavior
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. |
#2
|
|||
|
|||
Do you have any event macros running?
What do you see in the cell when you format it as General? In article , CraigH wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
format the "date" button for a header | Excel Discussion (Misc queries) | |||
Conditonal Format with a date format | Excel Discussion (Misc queries) | |||
How to format a date to a different format | Excel Discussion (Misc queries) | |||
Date Format Question | Excel Discussion (Misc queries) | |||
Problem with Date format from VBA code | Excel Discussion (Misc queries) |