software

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 quot;zip suffix
field is not blankquot;. (The quot;otherwise insert this textquot; 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
quot;ignore this errorquot; 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?

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!
quot;Marushelquot; wrote:

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

The message is quot;The number in the cell is formatted as text or preceded by
apostrophe.quot; The menu options when I click there a
-Convert to number
-Help on this error
-Ignore the error
-Edit in formula bar.. etc.

I am not sure why the error is being displayed even after all the cells are
formatted as text. However, even after the triangle is made to disappear by
clicking on ignore error, I am not getting Word to be able to read from some
of the cells after merging. Word is perfectly able to read the Zip and zip
suffixes stored as text in other cells, but is not able to do so for some
other cells. I am not sure what could be causing this because all the cells
are formatted as text.

Will appreciate any suggestions or advice.

Marushel
quot;paulquot; wrote:

gt; what was the error or variation denoted by the green triangle?excledisplays
gt; the green tringle when the data or formula differs from the data/formula
gt; around it
gt; --
gt; paul
gt; remove nospam for email addy!
gt;
gt;
gt;
gt; quot;Marushelquot; wrote:
gt;
gt; gt; Hello, I have been trying to figure out the source of this error for several
gt; gt; hours without any results and hope someone can help me. I have been using an
gt; gt; Excel file to create a merge letter in word. So far it has been working like
gt; gt; a charm and the problem started just after I entered some new records.
gt; gt;
gt; gt; In my word merge letter after the City, State, and Zip fields, I have a
gt; gt; word field, which is set to insert a hyphen after Zip field if quot;zip suffix
gt; gt; field is not blankquot;. (The quot;otherwise insert this textquot; is left blank). This
gt; gt; is followed by the zip suffix field. This is intended to show both the zip
gt; gt; and zip suffix separated by a hyphen if some addresses do have a zip suffix.
gt; gt; So far, this has worked fine, but after my latest entry of new records in the
gt; gt; Excel worksheet, green corners started appearing in the zip and zip suffix
gt; gt; fields though both the fields are formatted as text. I manually clicked
gt; gt; quot;ignore this errorquot; and the flags went away. However, now whenever I am
gt; gt; merging, for most of the old records, the State, zip and zip suffix are
gt; gt; appearing as they should (e.g., PA 1823-1234 or PA 18723), but for all the
gt; gt; new records that I have just entered, the Zip and zip suffix are appearing as
gt; gt; 0 (when there is no zip suffix) and as 0-0 when there is a zip suffix. I am
gt; gt; stumped and am unable to figure out why this is happening. What went wrong?
gt; gt; Can someone please help?