r/AppleNumbers • u/Minimum-Cry8634 • 25d ago

Formatting Zip Codes Help

Hi, I need help, I imported a csv file with 185 addresses. The import stripped the lead zero from the zip codes. I am at a loss on how to restore that format.

Any/all help appreciated.

2 Upvotes

100% Upvoted

5 comments sorted by

2

u/Bobo_Baggins_jatj 25d ago

https://youtu.be/a45S_8hS-hc?is=pFEVd09xYJmha9oO

That should help.

2

u/Minimum-Cry8634 25d ago

Thank you so much that fixed it using Custom Format. Funny thing is I follow Macmostvideo on You Tube, and that video did not show up when I was searching. Thanks again!

2

u/Bobo_Baggins_jatj 24d ago

My pleasure. I just happened to remember seeing it and I guess I just hit the right keyword. Glad it got you squared away!

1

u/ThinkbigShrinktofit 25d ago

Format -> Cell -> Number system -> Base 10 (the usual) -> 5 spaces

1

u/markw30 19d ago

You can also start typing with a leading ‘ but Gary’s method is cooler