Why do I see a strange format of some of my bank account numbers in Excel export file?
Harvester Payroll help topic
Read the help answer below and, where available, watch the matching Harvester YouTube training video.
Browse Help Topics / Results Open help answers here after searching above
| Key Word |
Topic Title Click to open |
Help Answer & Related Training |
|---|---|---|
| Bank Account Numbers in strange format |
Why do I see a strange format of some of my bank account numbers in Excel export file?
Click this Topic Title above to open the full help page
and view any related training video if available.
|
Why do I see a strange format of some of my bank account numbers in Excel export file?
For bank account numbers longer than 11 digits e.g. 9130000412043 in the bank column, AFTER you have exported to excel you might see something like "9.1E+12".
This is Scientific Notation for large numbers and is quite normal. Leave it as is. The banks will read the numbers correctly when you send them the excel or csv file.
If you select the exact cell where you see a Scientific Notation number and look at the top of your spreadsheet in the actual cell reference you will see the proper number of 9130000412043(for our example).
Do not change this. This is correct.
The bank will read the numbers properly.
|
Harvester Payroll Training Videos
Browse short, step-by-step Harvester Payroll videos. Each video has a dedicated page connected to the relevant Help topics, with an option to continue watching on YouTube.
Open Training Videos Hub