I have an excel document, with formulae in which creates the results in % to
2 decimal points. I need to merge this info into a document in word. I've
followed the Graham Mayor suggestions in his document (found through this
site) but it's not working.

I get a syntax error with { ={mergefield"AB_2004"} * 100 \ # "0%"}. If I
take out the =} I get 0% not the result. I added 0.00% and got 0.05%, again
not the result but the right format.

Any more clues please??

You didn't get that structure from my web site - at least not as you have
entered it.
It should read:

{={Mergefield AB_2004} * 100 \# "0.00%"}

for two places of decimal. Note the spaces!

What does {Mergefield AB_2004} produce on its own?

I take it that you have used CTRL+F9 for the field boundaries?

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Laurina wrote:
I have an excel document, with formulae in which creates the results
in % to 2 decimal points. I need to merge this info into a document
in word. I've followed the Graham Mayor suggestions in his document
(found through this site) but it's not working.

I get a syntax error with { ={mergefield"AB_2004"} * 100 \ # "0%"}.
If I take out the =} I get 0% not the result. I added 0.00% and got
0.05%, again not the result but the right format.

Any more clues please??

Thanks for your prompt response Graham.

AB_2004 is the field name of the info in Excel. % exam pass rates (I work in
education). In Excel they display as %'s ie. 98.34%. There's lots of info
that I'm trying to formulate into a single document per subject.

I've copied your formula {={Mergefield AB_2004} * 100 \# "0.00%"} (the first
and last brackets are bold - which is presumably the field boundries) and
still get a syntax error.


"Graham Mayor" wrote:

You didn't get that structure from my web site - at least not as you have
entered it.
It should read:

{={Mergefield AB_2004} * 100 \# "0.00%"}

for two places of decimal. Note the spaces!

What does {Mergefield AB_2004} produce on its own?

I take it that you have used CTRL+F9 for the field boundaries?

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Laurina wrote:
I have an excel document, with formulae in which creates the results
in % to 2 decimal points. I need to merge this info into a document
in word. I've followed the Graham Mayor suggestions in his document
(found through this site) but it's not working.

I get a syntax error with { ={mergefield"AB_2004"} * 100 \ # "0%"}.
If I take out the =} I get 0% not the result. I added 0.00% and got
0.05%, again not the result but the right format.

Any more clues please??

What I wanted to know was what you get if you insert {Mergefield AB_2004}
into the document without a calculation ie the result of merging that field.

There are * two fields* and thus *two sets* of field boundaries in that
construction one around the calculation, the other around the mergefield. If
the fields are inserted by hand rather than from the toolbar, both are
inserted with CTRL+F9. I have now coloured this information in red on my web
site to draw attention to it.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Laurina wrote:
Thanks for your prompt response Graham.

AB_2004 is the field name of the info in Excel. % exam pass rates (I
work in education). In Excel they display as %'s ie. 98.34%. There's
lots of info that I'm trying to formulate into a single document per
subject.

I've copied your formula {={Mergefield AB_2004} * 100 \# "0.00%"}
(the first and last brackets are bold - which is presumably the field
boundries) and still get a syntax error.


"Graham Mayor" wrote:

You didn't get that structure from my web site - at least not as you
have entered it.
It should read:

{={Mergefield AB_2004} * 100 \# "0.00%"}

for two places of decimal. Note the spaces!

What does {Mergefield AB_2004} produce on its own?

I take it that you have used CTRL+F9 for the field boundaries?

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Laurina wrote:
I have an excel document, with formulae in which creates the results
in % to 2 decimal points. I need to merge this info into a document
in word. I've followed the Graham Mayor suggestions in his document
(found through this site) but it's not working.

I get a syntax error with { ={mergefield"AB_2004"} * 100 \ # "0%"}.
If I take out the =} I get 0% not the result. I added 0.00% and got
0.05%, again not the result but the right format.

Any more clues please??