Arise Software Ltd

Support and Help Docs

1. November 2018 11:32
by Admin
0 Comments

Excel Bank Accounts Numbers

1. November 2018 11:32 by Admin | 0 Comments

Excel will remove zeros at the beginning of bank accounts, when opening a CSV file. If opening the file in notepad, it can be seen the bank # are intact. Best attempt to get it opening in Excel as follows:

Open file in notepad, click Edit then Replace

Find ,”0 (that is comma | double quote | zero) and replace with ,””0 (that is comma | double quote | double quote | zero)

Open file in Excel and select the bank account column by clicking on the column header to select the entire column

Right click, select Format Cells

Select Custom, then Type to be 0, click OK

It will not be perfect but at least the full account number can be seen.