Zip Code Format, commas and first digit 0 problem

[brooksey]

Hi There
Have an issue I am not able to figure out?
I have 5000 zip codes that need a comma placed at the end of it, some zip codes start with a 0 digit. This is not a big deal, change the format to zip code fixes the 0 issue and format the cell with a =A1"," command....However, the problem is getting the 0 to stick and the coma together. WIth the special format, it is dumping the 0 and leaving the comma? Anyone have a fix? I must be overlooking something...
Thanks

[Fotis1991]

Hi brooksey and welcome in the forum

A posible solution is this:

Format A1, as TEXT

IN B1, type this: =A1&","

Is it OK?

Hope to helps you

[brooksey]

Thank you.
This still truncates the initial 0 ?
so zip code 01005
I want to change it to 01005,
this is what I am getting: 1005,

[Fotis1991]

Hi again

Pls take a look to the attachment

Hope to be OK, now.

[brooksey]

Attachment looks great. When I change the data back to text the 0 disappears ? I must be missing something?

[shg]

With a number in A1 (e.g., 1005), =TEXT(A1, "00000\,")

[Fotis1991]

You can't change the format and take your result.

You have to greate the list, using text format, OR, add to the formula, as many Zeroes, as you want, like this:

=0&0&0&Α3&","

Now???

[brooksey]

thx shg and fotis....got it. I learned something.

[Fotis1991]

Glad to helped you..