formatting table cells for dollars and percentage for merge documents

[Larry Davsko]

Using office XP I have found that using formatted Dollars
& Percentages in the spreadsheet that is to be used as
the merge table for a word document doesn't work.

I have copied the spreadsheet into a word table but I
can't find out how to format the cells with dollars and
percentages so they show up properly in the merged
document. Help?

 

[Doug Robbins - Word MVP]

Hi Larry,

In the mailmerge main document, use Alt+F9 to toggle on the field codes and
inside the closing } of the respective fields, add one of the other of the
following numeric picture switches as applicable

\# "$#,##0.00"

\# "0.00%"

modifying the number of decimals shown in the above to suit your
requirements.

Please respond to the newsgroups for the benefit of others who may be
interested.

Hope this helps
Doug Robbins - Word MVP