View Single Post
  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Annette Annette is offline
external usenet poster
 
Posts: 29
Default How do I use field codes to format a number into currency?

It works!!! I've been looking for this ever since we switched to Windows XP
and Office 2007. I have problems with percents, also - what would I add to
the code to keep the number as a percent rather than reverting to a decimal?

"Doug Robbins - Word MVP" wrote:

Press Alt+F9 to reveal the field codes and insert

\# "$,0.00;($,0.00)"

before the closing }



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

"Andrea" wrote in message
...
I would like to format my numbers in a mail merge to be shown as Currency
so
with $ and 2 decimals. I know I can do this with a field code but can't
get
it to work.