adding a comma at the end of a number to every cell

[Jeff]

I have 22,000 cells with zip codes. I need to add a comma
at the end of every number. Does anyone know how I can do
this?

 

[Judy Freed]

Someone may have a better way but this worked for me. But please try it on a
copy of the worksheet in case I am not understanding you correctly. Say my
first zip code is in cell A1. In cell B1, enter the formula

=A1&","

and copy it down. This causes column B to contain the zip code with the
comma after it. Then I copied Column B and used Edit, Paste Special, Values
to paste it over Column A.

Judy Freed

 

[Ken Wright]

If you tell us why you need to do it, and what you aim to achieve, we may be
able to suggest a more effective route.

 

[Myrna Larson]

Rather than changing the data, if these are all 5-digit zip codes (i.e. all numeric, no 9 digit
with a dash -- which makes them text), you can use a custom number format: #\, or 00000\,