Excel is changing my dates

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

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.
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.