why does excel change my dates

July 13, 2011 at 12:27:52
Specs: Windows Vista
excel insists on changing the year I enter (such as 2005) to the current year (2011) after I have specifically formatted the cells in the date format I selected. For example, I enter 5/2005 and end up with 5/2011. No matter what date format I select from the drop-down, it keeps doing this.

See More: why does excel change my dates

Report •

July 13, 2011 at 12:57:55
I formatted some cells as Custom m/yyyy

When I enter 5/2005 it displays 5/2005 and shows 05/01/2005 in the fomula bar.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

July 13, 2011 at 12:58:05
Are you using a Custom Format?

What appears in the Formula Bar when you enter 5/2005?

When I custom format cell A1 with: M/YYYY
and enter 5/2005 it shows 5/1/2005 in the Formula Bar
but the cell displays 5/2005.



Report •
Related Solutions

Ask Question