Excel is changing my dates

Closed
Report
-
 tj -
Hello,
Why does Excel change my dates when I sort the date column?

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
give one or two examples.
We have one column of dates in format of mm/dd/yyyy, next column of type of action or purchase, next column dollar amount, etc. When we sort the date column, excel would actually change some of the dates. I posted this on another message board and someone suggested highlighting everything, not just the date column, and that seemed to do the trick. I don't know why, and that bothers me, but I'm satisfied for now to be bothered and have the problem solved. Thanks for your reply, though.

TJ