I want to sum the text entries of the numbers, how do I do it, Please.

VSC

"Peo Sjoblom" wrote:

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.