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

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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
 
Back
Top