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 use "Spotlight Search" on Windows?

Discuss in The Lounge

Poll History