Ask Your Question

when i download the file contains bank account numbers its automatically erase leading zeroes what i do

asked 2018-09-05 14:28:29 +0200

Ranjeet gravatar image

leading zeroes automatically removed from a bank account numbers

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2018-09-05 19:04:13 +0200

erAck gravatar image

Assuming that the file is imported as CSV (Comma Separated Values), in the CSV import dialog select the column in question and set its type to Text.

edit flag offensive delete link more

answered 2018-09-06 03:25:33 +0200

paradigm gravatar image

Right-Click on the column and chose "Format Cells"

Leave it on"Number" in category and go to where it asks how many "Leading zeroes:" Put in how many digits your number is. In the example below for a 10 digit number I put 10 for Leading zeroes.

Press ok, and now the cells will fill all the empty place values with 0s.

image description

edit flag offensive delete link more


When talking about identifiers, it might be better to not use numbers' leading zeroes, but to stick to text (as @erAck proposed), because sometimes identifiers need to be precisely as they are set initially, and some of them might have a different length (imagine a case with shorter legacy identifiers vs longer new identifiers).

Mike Kaganski gravatar imageMike Kaganski ( 2018-09-06 09:17:18 +0200 )edit

Also, using a number format changes the display representation but does not affect the cell content, so using VLOOKUP() or other operations that expect the exact account number string with leading zeros may fail.

erAck gravatar imageerAck ( 2018-09-06 12:51:42 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-09-05 14:28:29 +0200

Seen: 44 times

Last updated: Sep 06 '18