Excel is changing my dates

Closed
tj - Feb 6, 2010 at 12:07 PM
 tj - Feb 6, 2010 at 09:21 PM
Hello,
Why does Excel change my dates when I sort the date column?
Related:

1 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Feb 6, 2010 at 08:32 PM
give one or two examples.
0
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
0