date in wrong format

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

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?
 
You should also be able to type 1 into a cell, copy it and paste special on
top of your dates - Multiply.

Should force format to what you want.
 
Back
Top