Excel. Can die in shit. Preferably soon.

[wraithwitch]

So. Excel

Comments

[evilref]

I would guess you need to re-format the dates in the date column. If you highlight them and then use the format option off the menus, you might be able to choose a format that makes them come up the way they are supposed to.
But I am not a "power user" either, I'm afraid, so I might be wrong.

[wraithwitch]

Select the offending column and the offending column only.
Format it to be dates written a particular way...

Joy! Column B with weird dates now behaving.

Pants! Column A which was invoice numbers has mysteriously turned to dates.

Fuck - Excel will now not undo this change.

*wah*
was a good idea though.
*sigh*

[anonymous_james]

Highlight the column and apply the appropriate format to it - change it to "Number"?

[evilref]

1) Save_as a new file
2) close Excel
3) open new file you saved
4) hope it saved it correctly

I'm sort of guessing here, but it sounds like Excel has got confused.

[muppethex]

Try it in Openoffice
I find it generally does what you tell it to, rather than MS Office, which does what it thinks you meant to do.

[muppethex]

Also, it seems Excel's internal date format is Deliberately Buggy which might explain it, if you have the date storage format set differently in the new worksheet.