Rectifying the incorrect date format from the Microsoft Excel export.

Rectifying the incorrect date format from the Microsoft Excel export.

This error occurs when exporting reports from Statement-Matching.com to Microsoft Excel in that the dates displayed on Statement-Matching.com shows as 20/05/2015 and are exported to Excel as 15/05/2020.
This can be corrected by changing the short date format to DD/MM/YYYY on your personal computer's "Region and Language" settings.
Steps to change the settings are:

1) Go to Control Panel;
2) Select "Clock, Language and Region";
3) The "Formats" tab, you will see the Short date format.
      3.1) Go the drop-down list under "Format" and select "English (United Kingdom)";
4) If format does not change to DD/MM/YYYY format, it can be manually changed under the "additional settings" button on the bottom of the same screen.