Excel into word

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Laurina - 14 Sep 2005 11:02 GMT

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

Reply to this Message

Graham Mayor - 14 Sep 2005 12:49 GMT

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?

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

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

> 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
[quoted text clipped - 6 lines]
>
> Any more clues please??

Reply to this Message

Laurina - 14 Sep 2005 14:16 GMT

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.

> You didn't get that structure from my web site - at least not as you have
> entered it.
[quoted text clipped - 18 lines]
> >
> > Any more clues please??

Reply to this Message

Graham Mayor - 15 Sep 2005 06:56 GMT

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.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

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

> Thanks for your prompt response Graham.
>
[quoted text clipped - 37 lines]
>>>
>>> Any more clues please??

Reply to this Message