How to add leading zeros and put data in specific format?

[mshapps]

Hello,

I have an excel column with thousands of rows that look similar to the following:

2130724
11130000
22288,133,000

I basically need the first two lines to be in the same format as the third line and to add leading zeros. (without modifying the 3rd line)

For example:

00002,130,724
00011,130,000

I tried to change it using the following:

=TEXT(B2,"00000,000,000")

But this only changed it to:

00,002,130,724
00,011,130,000

Any help is appreciated.

 

[Mr_Roscoe]

mshapps - welcome and try this:

=REPT("0",11-LEN(B2))&TEXT(B2,"#000,000")

 

[mshapps]

Thanks that worked!!