Assuming that you are hand-keying these zip codes, just
put an apostrophe (') in front of the zip code. That will
keep the 0 in the front and it shouldn't present a problem
when uploading into the UPC software.
I am not hand keying. I have exported the file from an
accounting package that is used in UNIX. Is there a way
to ad an apostrophe and the zeros so that all the data in
the zip field is formated as zip code when you look at it
in the formula bar? The formula bar showes without zeros
even after formatting with zeros.
How about just formatting the cell(s) as Zip (or Zip+4).
They'll look pretty on the worksheet -- not quite so in the formula bar.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
