what was the error or variation denoted by the green triangle?excledisplays
the green tringle when the data or formula differs from the data/formula
around it
--
paul
remove nospam for email addy!



"Marushel" wrote:

Hello, I have been trying to figure out the source of this error for several
hours without any results and hope someone can help me. I have been using an
Excel file to create a merge letter in word. So far it has been working like
a charm and the problem started just after I entered some new records.

In my word merge letter after the City, State, and Zip fields, I have a
word field, which is set to insert a hyphen after Zip field if "zip suffix
field is not blank". (The "otherwise insert this text" is left blank). This
is followed by the zip suffix field. This is intended to show both the zip
and zip suffix separated by a hyphen if some addresses do have a zip suffix.
So far, this has worked fine, but after my latest entry of new records in the
Excel worksheet, green corners started appearing in the zip and zip suffix
fields though both the fields are formatted as text. I manually clicked
"ignore this error" and the flags went away. However, now whenever I am
merging, for most of the old records, the State, zip and zip suffix are
appearing as they should (e.g., PA 1823-1234 or PA 18723), but for all the
new records that I have just entered, the Zip and zip suffix are appearing as
0 (when there is no zip suffix) and as 0-0 when there is a zip suffix. I am
stumped and am unable to figure out why this is happening. What went wrong?
Can someone please help?