The reason is that you have error checking turned on and it warns against
text numbers because 9/10 you wouldn't want that but unless you want to add
some switches in Word that's the way to go


--


Regards,


Peo Sjoblom



"Orrie" wrote in message
...
Thanks Peo, it worked, although I had to try it twice until it did. The
first time, there was a little error icon next to the cell. The error was
supposed to be an apostrophe preceding the numbers. There was no
apostrophe, but I deleted the entry, retyped it and then selected the
setting in Format Cell to accept the entry with the "error," the entry
worked.

Orrie

"Peo Sjoblom" wrote in message
...
Format the cell as text before entering

--


Regards,


Peo Sjoblom

"Orrie" wrote in message
...
Hi,

I am entering addresses into an Excel worksheet the I need to use in a
mail merge. One of the addresses has a five digit postal zip code that
begins with a "0" (zero.) I typed it in like any other zip code entry,
but Excel dropped the zero as soon as I moved to the next cell. I tried
converting the entry into "text," but when I printed the record, only
the zero printed.

Other zip codes that do not start with zero work fine in a mail merge
and in printing the records.

How can I enter a zip code that begins with a zero, so it will appear
properly in Excel and in a mail merge?

Thank you.

Orrie