Solved Excel is changing my spreadsheet dates to x's or numbers

March 23, 2013 at 14:59:51
Specs: Windows 7
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?

See More: Excel is changing my spreadsheet dates to xs or numbers

Report •


#1
March 24, 2013 at 04:35:55
✔ Best Answer
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-0

Try 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

http://www.skeptic.com/


Report •

#2
March 24, 2013 at 09:27:14
Sorry, they are #'s. I'll try reformatting and see what happens. Thanks for responding.

Report •

#3
March 24, 2013 at 09:49:18
If it turns out not to 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

http://www.skeptic.com/


Report •

Related Solutions

#4
March 24, 2013 at 12:26:06
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.

Report •


Ask Question