are really annoying me! I'm doing an excel spreadsheet of all my guests addresses and it WILL NOT recognize the '0' in all of the NJ zip codes I had to use the letter 'O'.
ok vent over. thanks!
PreshusSmurf
Posted:
Member since
Re: Ugh NJ's zip codes...
Make sure you change that before you submit the list to a calligrapher if you're using computerized calligraphy ... or it could print out that way
Jess and Jon
Posted:
Member since
Re: Ugh NJ's zip codes...
That happens to me ALL the time at work...I hate it!!
ace730
Posted:
Member since
Re: Ugh NJ's zip codes...
There is a way on Excel where you can switch it to Zip Code so it doesn't do that. I used to hate that!
dana1206
Posted:
Member since
Re: Ugh NJ's zip codes...
If you type them in with an apostrophe (sp?) before the first number, it will show up without the apostrophe but won't get rid of the zero since it doesn't think it's in number format. Good luck!
LiLMich
Posted:
Member since
Re: Ugh NJ's zip codes...
I just had the same problem, it is soooooo annoying!!!
thenewmrsharrington
Posted:
Member since
Re: Ugh NJ's zip codes...
you can also change the format of the cell to text.
