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.