Mike this is a little long winded but I found it helpful in resolving many a
format problem:
http://support.microsoft.com/default...;en-us;Q264372

"Mike" wrote:

My mo/da/yr format somehow changes to a 5 digit entry - 393xx. I have tied
the normal procedure of format cells, date, etc. but that won't fix it. What
can I do?