Word Merge with Excel Data Source

[Katy]

This is a recent occurrence, since adding XP SP2 and Office SP3. The excel data source is adding a zero (0) value to an empty cell, cell format is text only.

This doesn't show up on the excel spreadsheet itself, but when selecting the data source from the Merge wizard. And it is inconsistent. Other empty cells remain empty in other fields, same cell format - text only.

Does anyone have a solution to this problem? Thanks.

Kate

 

[macropod]

Hi Kate,

You could overcome this with an IF test for your MERGEFIELD:
{IF{MERGEFIELD Data}= 0 "" {MERGEFIELD Data}}
or, if you're dealing with purely numeric data, a numeric picture switch in your MERGEFIELD will do. For example:
{MERGEFIELD Data \# 0;-0;}
or
{MERGEFIELD Data \# $,0.00;-$,0.00;}
This form of numeric pictire switch suppresses 0 values.

Cheers