Blank Cells in Excel producing zeros in mailmerge Word document

[Cottager]

I am trying to import an excel file into a mailmerge word document and not
all of the rows have the same amount of information which leave blank fields.
These blank fields are displaying as zero on the word document. How do I
eliminate these zeros?

Also, why don't cells set as currency hold the dollar sign when merging?

 

[G and C at RSC]

I have posted a similar question today, regarding the blank fields being
displayed as zero. Have you managed to solve this one yet?

 

[Doug Robbins - Word MVP]

See response to his similar post made eleven minutes before this one.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP