Sometimes when using Excel to view your reports the sort code can show up in date format. There's no way to preserve the sort code data at the initial download. However it can be fixed by following the below steps:
Download the csv file export from eDD but don't open, just Save as.
Open Notepad then go to FILE and open. Find your csv file and open it.
Save the note pad file.
Open a blank excel worksheet.
Click on the data tab, then from text.
Select the note pad file you previously saved.
Double click on file name β this will bring up the text import wizard.
Choose the file type delimited then next.
Choose comma then next.
Scroll along to the sort code and account number fields and highlight them, in the column data format choose text.
Click finish.
This then preserves the data as a sort code and also prevents the preceding zeros from disappearing.