String Functions

[LeeBee]

Having problem using functions and need assist.
Am trying to left pad a column with zeros to make all values in column 9 characters.
Below is sample of working function.

Pasting that function in actual data we see the following with no padded result:

What am I doing wrong??
Any help is appreciated.

Lee

 

[Fluff]

Hi & welcome to MrExcel.

Change the cell format to General & renter the formula.

 

[LeeBee]

Hi & welcome to MrExcel.

Change the cell format to General & renter the formula.

Mr Fluff:

Thanks for quick response - worked great!

Regards,

LeeBee

 

[Fluff]

You're welcome & thanks for the feedback.

 

[Scott Huish]

If your values would never go over 9 characters by themselves, you could just do this:
=TEXT(A1,"000000000")

 

[Sektor]

As another option:

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