View Single Post
  #5   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?

Wow...a lot of info! Let's see if I picked the correct one - I would add *
100\# "0%" before the closing }. And it looks like there's a space between *
and 100, and between # and ".

"Graham Mayor" wrote:

See http://www.gmayor.com/formatting_word_fields.htm

--

Graham Mayor - Word MVP

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



Annette wrote:
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.