How to Add 0s before Numbers in Excel

[329805997]

Hi there,

I have a question about how to add 0s before numbers in Excel.

For example, I have 12354 84 21354484787 123456789123456, but I want them to be 15-digit numbers.

So, I add 0s before the numbers, and they will be 000000000012354 000000000000084 000021354484787 123456789123456.

How can I make the change? I have 260k numbers so I do not want to do it manually...

Thanks
Yin

[oteixeira]

Hi,
Suposing 12354 is in A1 enter the following formula in B1:

=REPT("0";15-LEN(A1))&A1

Hope this helps

[329805997]

Thank you genius

[AlKey]

Here is another way

=TEXT(A1,"000000000000000")

v	A	B
1	12354	000000000012354
2	21354484787	000021354484787
3	1.23457E+14	123456789123456

[329805997]

Thank you!

[IronCladRooster]

Or if you just need it to look like there are a bunch of extra 0's in front of every number you could go in to custom number formatting and type in 15 0's in the custom Type field. You wouldn't have to mess with any formulas that way.