My spreadsheet is several pages long and I had a date column using the format mm/dd/yy. Excel is replacing my dates with x's or numbers. What do I need to do to keep my dates?

Are the numbers five digits like: 41357 If so, then it's possible those are DATES,

Excel stores dates as a number representing the number of days since 1900-Jan-0Try reformatting the numbers and see what you get.

As for the X's, are they X's or Hash Marks: ###

If Hash marks, it just means the cell is to small to display the date,

if there X's then I have no idea.MIKE

Sorry, they are #'s. I'll try reformatting and see what happens. Thanks for responding.

If it turns out notto be the cell width,

then check to make sure the cell does not contain a negative number.

If a Date/Time cell contains a negative number you will also get the ###MIKE

I deleted the format for the cell and had to set it as text to make the date stay. Sometimes it went from #### to a number and I had to clear contents too. So far it is working today. Thanks for your help.

Ask Your Question

Weekly Poll

Would you ride in a self-driving car from Tesla?

Discuss in The Lounge

Poll History