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.
I am importing addresses for my wedding.
What version of Numbers do you have? I was demo'ing from Numbers '09 (version 2.2)
08' 1.0.3
you can add a new coumn following the zip code and enter the foloowing formula, then fill down as needed:
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?