Zero's missing when exporting data?

Problem reported by Gareth Ricketts 2 years ago

Trying to export data using the BACS export tool:

Tools: Export: Export Data: Data Type: Unpaid Bills (BACS)

But the leading zeros from sort code or bank accounts do not pull through?

Any suggestions please as this is impacting my payments?

Thanks

Solved
clearbooks
  • Accounting/Home Accounting
  • Home
Write reply3

3 Replies

Hi Gareth,

This is how Excel would usually treat leading 0s on a spreadsheet. I will double check this with our Developers to see if there is anything we can do on our end.

Tommy

2 years ago

Hi Gareth,

I have double checked this with our Developers and can confirm the export does not strip out the leading 0s.

It appears Excel is automatically formatting the sort code column as number, which leads to stripping the leading zeroes on display. In this case, you will need to change the data type on the cells of the sort code and account number columns. Unfortunately, we are unable to change the behaviour of Excel's automatic detection.

Tommy

2 years ago

Reply to this problem

Attach images by dragging and dropping or upload
 

Your comments will be public and can be answered by anyone in the Clear Books community.

Find out what we do and who we are

Apps

Company

Social