Mail Merge Formatting

[lpriest]

I'm trying to merge data from an excel spreadsheet. The data is formated as
a percentage ie 97.2% but of course comes through the merge as
0.971999999999. I've tried using Words switch \#"##%" and many variations of
that but I keep either getting just a % sign or 1%. What am I doing wrong?

 

[Doug Robbins - Word MVP]

The data is actually stored in Excel as 0.971999999999 to get it to be
displayed as 97.2%, as well as using the formatting switch, it will be
necessary to put the mergefield inside a calculation field where it is
multiplied by 100

{ = (100 * { MERGEFIELD fieldcontainingpercentage }) \# "##.#%" }

--
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