Skip to main content

Customer upload error: Sort codes

Error message 'BankSortCode can only be 6 characters long and only numbers'.

O
Written by Ollie Denning

There must be exactly six numbers for each entry in column R.
​
To ensure any preceding zeros are recognised, you'll need to adjust the number format for the cells in column R.
To do this you'll need to right click the column header (R) and select Format Cells from the menu. Then select CUSTOM and add 6 0s into the TYPE field, as per the screenshot below:

πŸ“ŒNote: If you reopen the file and make any changes before uploading to Access PaySuite DDCMS, you'll need to apply the above format to the cells again before saving and uploading.

Did this answer your question?