Add a leading zero

[rebel123]

I am trying to add a leading zero. I tried to do =TEXT and it did not work.

I just need an equals sign answer. The correct answers are under parcel 2

Parcel 1	Parcel 2
1357935	01357935
1053167	01053167
1009508	01009508

EDIT: Not sure if my columns are formatted wrong... I have them formatted as text

 

[Joe4]

When you use TEXT, you need to tell it how many digits, i.e.

=TEXT(A2,"00000000")

 

[rebel123]

OK thanks! Worked good!

I was doing it with
=TEXT(A2,"0")

and it was not working.

Thank you!

 

[Joe4]

You are welcome.
Yes, the second argument in the Text function works just like a Custom format. You need to specify each of the digits in this case, since you want it to be 8 characters long.