Add missing zero's to customer number

[Johnnyb]

I am working on a sheet with customer name & customer number. Th
customer numbers should all be 6 digits yet some of then have 5, 4 an
3 digits.
Is there a formula to look at each customer number and add leadin
zero's to the number to make up 6 digits.

e.g if I have a 3 digit number 123 to make up 6 digits it would b
000123.

Any help would be much appreciated,
Regards,
Johnny

 

[Jason Morin]

One way:

=REPT("0",6-LEN(A1))&A1

Another:

=TEXT(A1,"000000")

HTH
Jason
Atlanta, GA

 

[Govind]

Hi,

Try

=IF(LEN(A1)<6,REPT(0,6-LEN(A1))&A1,A1)

Govind.

 

[Johnnyb]

That's great thanx