Mail Merge Formatting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

lpriest - 16 Jun 2006 14:38 GMT

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?

Reply to this Message

Doug Robbins - Word MVP - 16 Jun 2006 18:14 GMT

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 }) \# "##.#%" }

Signature

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

> I'm trying to merge data from an excel spreadsheet. The data is formated
> as
[quoted text clipped - 3 lines]
> that but I keep either getting just a % sign or 1%. What am I doing
> wrong?

Reply to this Message

Rate this thread: