L
lj_99_99
I'm having a problem with a particular spreadsheet. Some of the cells have
dates, typed in MM/DD/YY format, but Excel isn't recognizing it as a date. It
won't change the date format (to MM/DD/YYYY) or sort these dates along with
other "normal" date cells.
I can't seem to figure out what's the problem with these particular cells.
When I type a random number like 123 into the cell, it converts it to a date
format, but I want it to recognize 1/23/06 as a date and it doesn't.
Anyone have any idea of what's going on? It works fine for SOME cells in the
spreadsheet, and I have no issues when creating a new Excel file. The
document in question was e-mailed to me, so I'm not sure how it was generated
(but I assumed it was just typed manually).
dates, typed in MM/DD/YY format, but Excel isn't recognizing it as a date. It
won't change the date format (to MM/DD/YYYY) or sort these dates along with
other "normal" date cells.
I can't seem to figure out what's the problem with these particular cells.
When I type a random number like 123 into the cell, it converts it to a date
format, but I want it to recognize 1/23/06 as a date and it doesn't.
Anyone have any idea of what's going on? It works fine for SOME cells in the
spreadsheet, and I have no issues when creating a new Excel file. The
document in question was e-mailed to me, so I'm not sure how it was generated
(but I assumed it was just typed manually).