Excel is changing my dates

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

1 response

venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 811
6 Feb 2010 à 20:32
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