NOT MERGING %'s CORRECTLY

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sandi - 05 Feb 2007 17:54 GMT

I have an excel spreadsheet that I am using in my mail merge that has
percentages in it. When I try to merge my fields together, I keep getting
each number that looks like this 6200000000000002%. I have tried to go back
and check the formatting of my cells in Excel and they are set as
Percentages. I have tried entering in a specific field code {={MERGEFIELD
Van}*100\#"0%"} that was given to me from another posting with the same
problem, but I keep getting a Syntax Error. Is there something that I am
missing or doing wrong? Any help would be appreciated!

Signature

Sandi Gardner

Reply to this Message

Peter Jamieson - 05 Feb 2007 18:02 GMT

Both pairs of {} have to be the special field braces that you can insert
using ctrl-F9. They can't be the ordinary {} that you can type on the
keyboard. (Everything else can be ordinary text).

That's usually what has gone wrong, anyway...

Peter Jamieson

>I have an excel spreadsheet that I am using in my mail merge that has
> percentages in it. When I try to merge my fields together, I keep getting
[quoted text clipped - 5 lines]
> problem, but I keep getting a Syntax Error. Is there something that I am
> missing or doing wrong? Any help would be appreciated!

Reply to this Message

Sandi - 05 Feb 2007 18:18 GMT

I tried doing it that way and I still keep getting a Syntax Error. I put the
field code in, toggled between the field codes and used the Ctrl+F9 feature
to insert the {}. Put the formual in and still nothing but an error. HELP,
is there anything else or am I doing it wrong?

Signature

Sandi Gardner

> Both pairs of {} have to be the special field braces that you can insert
> using ctrl-F9. They can't be the ordinary {} that you can type on the
[quoted text clipped - 12 lines]
> > problem, but I keep getting a Syntax Error. Is there something that I am
> > missing or doing wrong? Any help would be appreciated!

Reply to this Message

Peter Jamieson - 05 Feb 2007 19:10 GMT

1. What is the result of
{ MERGEFIELD Van }
on its own ?

2. What is the result of (say)
{ =0.1*100\#"0%" }
on its own?

Peter

>I tried doing it that way and I still keep getting a Syntax Error. I put
>the
[quoted text clipped - 23 lines]
>> > am
>> > missing or doing wrong? Any help would be appreciated!

Reply to this Message

Sandi - 05 Feb 2007 20:14 GMT

GOT IT!!!!!!! WONDERFUL - How picky it is! Thanks soooo much!

Sandi Gardner

> 1. What is the result of
> { MERGEFIELD Van }
[quoted text clipped - 32 lines]
> >> > am
> >> > missing or doing wrong? Any help would be appreciated!

Reply to this Message