Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

When importing a .CSV into numbers I lose the 0 at the beginning of my zip codes, how do I get them back?

I am importing addresses for my wedding.

Posted on Nov 27, 2012 3:22 PM

Reply
5 replies

Nov 27, 2012 5:12 PM in response to DaDish1002

you can add a new coumn following the zip code and enter the foloowing formula, then fill down as needed:


User uploaded file

actual ZIP is in column C, new column "Aux ZIP" in column D:

D2=IF(LEN(C2)<5, "0", "")&C2


select D2 and fill down



now copy column D and paste values into column C (then remove column D). To paste values use the menu item "Edit > Paste Values"


Happy Wedding!

When importing a .CSV into numbers I lose the 0 at the beginning of my zip codes, how do I get them back?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.