View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Urgent...Word Mergefield Formula

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