View Single Post
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

Use text zips, precede the entry with an apostrophe or pre-format cells as
text and the leading zero will display

http://www.mvps.org/dmcritchie/excel/mailmerg.htm

Regards,

Peo Sjoblom

"cmreisner" wrote:

I need to have zip codes in a spreadsheet, but when I type in the zip code,
the zeros at the beginning disappear. How do I prevent this from happening.

For example, 01234 automatically turns into 1234 which won't be the correct
zip code when I mail merge the information.