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 & Training Video |
|---|---|---|
| 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.
|
New Harvester YouTube Training Course
Learn the latest Harvester Payroll step by step. Our newest YouTube playlist has over 30 short videos, most roughly 5 minutes each, so you can learn one topic at a time or complete the full course in under 3 hours.
Watch Harvester Training on YouTube