Zero Values in excel sheet are showing up as values in Word

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jimadmin - 13 Mar 2004 01:06 GMT

I am trying to merge an excel sheet of dollar amounts and dates into a word document. The word doc merge is showing values for empty cells in excel(dates are showing 12:00:00 AM and the numbers are showing up at 0). Is there a fix for this??

Reply to this Message

Graham Mayor - 13 Mar 2004 04:47 GMT

See the Excel data section of
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm.
You could also trap with conditional fields eg

{IF {Mergefield Number} <> "0" "{Mergefield Number \# ",$0.00"}

you need to check what the mergefield brings in without a mask and trap that
result.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP

Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> I am trying to merge an excel sheet of dollar amounts and dates into
> a word document. The word doc merge is showing values for empty cells
> in excel(dates are showing 12:00:00 AM and the numbers are showing up
> at 0). Is there a fix for this??

Reply to this Message