Concatenate Function drops Leading Zeros?

[binar]

Fellow Forum Members,
My objective is to concatenate column A with the prefix "Part #". What is making it difficult is that column A contains numbers with leading zeros that look like this:

0001
0212
0058
0022
0789
0852

Column A has the special Format known as Portugal Zipcode applied in order to generate all the leading zeros.

In cel B1, I am using this formula:
=Concatenate("Part # ",A1)

It adds the prefix "Part #" nicely, however the problem is that it drops the leading zeros from the all of the numbers in Column A generated using the zipcode format.

What is the proper way to code a Concatenate formula so that the leading zeros from Column A are not dropped when a TEXT prefix is added? Any help will be greatly appreciated. Thanks.

 

[shg]

Maybe ="Part # " & TEXT(A1, "0000")

 

[binar]

Maybe ="Part # " & TEXT(A1, "0000")

Shg,
Thanks a million! Your solution is awesome. What I find interesting is how it eliminate the need for using the special Zipcode column format. Very nice. Thanks again it works nicely.

 

[shg]

You're welcome, glad it worked for you.