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

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.

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

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 formatcellsnumberspecial 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


--
Regards,

Peo Sjoblom





"Foolish Aunt" wrote in message
...
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.

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

Success! THANK YOU!