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

Success! THANK YOU!