This object is in archive! 
Exporting customer list cuts off first digit of zipcode
Not a Problem
All of our customer's zip codes begin with '0' and it looks like they're getting removed during the export process.
Upon closer inspection, the data we export still has the first 0 in the zipcode. If you open with a plain text editor you can see this. It's the formatting of the spreadsheet editor stripping out the 0. You'll have to consult the user documention or customer support of your spreadsheet program in order to have better formatting.
Upon closer inspection, the data we export still has the first 0 in the zipcode. If you open with a plain text editor you can see this. It's the formatting of the spreadsheet editor stripping out the 0. You'll have to consult the user documention or customer support of your spreadsheet program in order to have better formatting.
Interesting. Ok, thanks. I'll see what I need to do to get excel to display the leading 0.
Thanks for looking into it for us
Interesting. Ok, thanks. I'll see what I need to do to get excel to display the leading 0.
Thanks for looking into it for us
are you using excel? or what spreadsheet?
are you using excel? or what spreadsheet?
Correct, we're using excel.
Correct, we're using excel.
To create a custom number format, follow these steps for all versions of Excel:
To create a custom number format, follow these steps for all versions of Excel:
you can also highlight the cell right click then pick format and then pick special and then zip code or what ever you need.
you can also highlight the cell right click then pick format and then pick special and then zip code or what ever you need.
I think if during the import you choose that column to be imported as text instead of a number, it will keep the leading zero.
I think if during the import you choose that column to be imported as text instead of a number, it will keep the leading zero.
Replies have been locked on this page!