More zip + 4 problems

D

dm

Dave Peterson: I did first copy a column of zip codes. The column has nine
digit numbers and five digit numbers. I pasted it into another worksheet,
selected Format, Special, zip + 4. Nothing happens until I double click one
of the cells and the format will change. The nine digit ones now display
correctly but the five digit ones will appear as 0001-2345 rather than 12345.
Is there any way around this?
 
D

Dave Peterson

You don't want to use Zip+4 as your number format.

Try a custom format of
Format|Cells|Number tab|Custom category
[>99999]00000-0000;00000

In that Type: box.
 

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.

Ask a Question

Top