Filling Adding Zero

[Jhon Mustofa]

hi all...

how to make adding zero like this :
1---001
10--010
100-100
etc..

would you have a solution?

any help much appreciated...

john m

[63falcondude]

Try something along the lines of this:

=RIGHT("00"&A1,3)

[than_gold]

Hello,
You can use the Text Formula as mentioned below by increasing the 0:

Please Login or Register  to view this content.

[Jhon Mustofa]

Hello,
You can use the Text Formula as mentioned below by increasing the 0:

Please Login or Register  to view this content.

little edit : =TEXT(A1,"000")

[alvin-chung]

alternatively you could simply format the cell with custom "000" without the need to apply any formula

[Jhon Mustofa]

thank you guys..

worked good!!!

[63falcondude]

Glad we could help. Thanks for the rep!