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.

