For example: I’ve exported a list of users from our account and I’m trying to sort it by date order, but some dates have gone in as text format and some as date format. When I change the text ones to dates it makes no difference and I can’t sort them either way.
The solution to this problem is to open the CSV file in Notepad or a similar application rather than Excel. You can change the file extension to .TXT instead and open it in a text editor. Excel tries to automatically format the cell type which can cause what looks like corruption problems.