Lost zero in front of zip codes

C

Carm

I have 3000 line items that lost the zero in front of the
zip code. How can I get it back. Been trying hard to
figure out what went wrong and how to fix. There must be
an easy solution.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cannot wrap text around an image 1
Set up and printing a 4-up mail merged postcard 0
Zip Code Last 4 Digit as Zero 1
How can I get a leading zero (ZIP code) to show in a LEFT() calc? 2
vlookup with zip codes - not working - frustrated 3
why is the zero falling off a zip code in excel? 3
Cumulative sum, based on previous data 0
First zero doesn't show up in zip code mail merge. 0

Top