Question
Why is the sort code showing as ###### or 12/34/56 instead of the usual 12-34-56, in export files?
Answer
This is caused when the sort code can be taken also as a valid date format, such as anything from 01-01-01 to 31-12-99 that can be taken as a date.
This is caused by the excel system automatically picking up the potential dates and converting them as such in excel.
Unfortunately, there is no conditional formatting on the export due to the file being a .csv
The only way to correct they is it to manually amend these within excel, or you can download the file and open this with another program other than excel.