View Single Post
  #5   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Urgent...Word Mergefield Formula

That certainly looks wrong.

What you should see is something more like what Graham suggested:

{={Mergefield 08APRGP} * 12 \# "$,0.00"}

What do you get if you just have

{Mergefield 08APRGP}


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

"Wendy7" wrote in message
...
Hi Graham,

I don't know if this helps but when I toggle field codes it returns the
following:

{ = *12\#"$,0.00"}{=*12\#",0.00"}

Thanks

"Graham Mayor" wrote:

You need to insert the field not just its name eg

{={Mergefield 08APRGP} * 12 \# "$,0.00"}

and the field 08APRGP must actually contain a number.

--

Graham Mayor - Word MVP

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


Wendy7 wrote:
Hello,

I'm trying to do a Merge and one of the fields in the merge I need to
multiply by 12. I was using just a simple formula: {=08APRGP*12
\#"$#,##0.00"}

And I'm getting a syntax error. Does anyone know a solution or the
issue to the formula?

Tank you!
Wendy