Solved excel 2010 loses date format

March 26, 2013 at 07:42:16
Specs: Windows 7 64 bits, i7-950 3.07GHz 6GB
All my Excel 2010 files on Win 7 64 bits have had their date formats changed from yy-mm-dd to yyyy-mm-dd; formats that were previously yyyy-mm-dd have been left unchanged.

This is very time consuming as I have to do format cells changes on every field of every tab of every file affected; because of the space factor, I need to use the shorter format.

I have woken up after spending hours on manual format cells changes and have thought of checking if my short date format in regional date formats had been changed...sure enough; I have made the correction and everything is back to normal.

The change must have been made by Windows update between 13/3/22 and 13/3/25; the only time I change formats is when I install a new version of Office (October 2010 in my case).

See More: excel 2010 loses date format

March 26, 2013 at 11:55:20
Since everything is back to normal, I assume this is just an FYI, correct?

I didn't want to leave your post as "Unanswered" so I am posting this response.

Office Forum Moderator

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

Report •

March 26, 2013 at 17:43:53
✔ Best Answer
You are correct; FYI and maybe for others with a similar problem.

Report •
Related Solutions

Ask Question