Issues, Workarounds & Localization

Hello,

It was recommended that I try posting this here. I am importing all wallet transactions for multiple characters from their XML data pages to an Excel spreadsheet. I am having the problem that when I import the data it comes together in the wrong order. It goes;

8/19
8/20
8/21
8/22
8/14
8/15
8/16
8/17
8/18
8/10
8/11

Etc, etc, etc. But, when I go to look at the XML data on the webpage it starts at 8/22 and goes in descending order. I do not seem to be able to sort the data by date in Excel (I assume because I am importing the data). Anyway, any help would be greatly appreciated since this is hurting my ability to organize the data and use pivot tables to read the data.

Thanks a lot for any help!