Leading 0s in zip codes suppressed - should be text or zip format

G

Guest

I have a data file that was given to me in .xls format - and all of the
leading 0s have been suppressed. How do I get them back?

Thanks.
 
P

Peo Sjoblom

Use a help column

=TEXT(A1,"00000")

(assuming your zip codes start in A1)

copy down, then copy and paste special over the source will give you text
with leading zeros

You can also use format>cells>number>special and select zip codes
that will change to the correct format but it won't export the leading zeros
if that's what you want
 

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

how do I eliminate leading "0s" in an alpha numeric cell 1
how do i eliminate leading 0 in a text cell 2
Show leading 0s for binary formatted cell? 1
Leadin 0s 1
Merge with Word losing zip code forward "0" 1
Zip Code formatting problem 3
leading 0s in zipcode missing when exporting to csv file 6
losing the leading zero when merging zip+4 postal code 1

Top