excel rounding off Zero of zip codes -don't want that

T

troy

how do you excel wizards deal with that from a beginner's
point of view. once i export the data into excel the
beginning zeros of zip codes drops off from view although
it appears if i click on the cell.

any suggestions?

thanks,
troy
(e-mail address removed)
 
G

Guest

Right click on the cell or cells you want as zip codes and
go to fromat cells. On the number tab, select special on
the left and zip code on the right.
 

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