Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Andrea Andrea is offline
external usenet poster
 
Posts: 40
Default How do I use field codes to format a number into currency?

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.
  #2   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 How do I use field codes to format a number into currency?

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.



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




  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default How do I use field codes to format a number into currency?

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.



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






  #6   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default How do I use field codes to format a number into currency?

It is the correct one, but you have not interpreted it correctly. Note the
extra field brackets {} inserted with CTRL+F9 around the whole.
This is a calculated field surrounding the mergefield.
--

Graham Mayor - Word MVP

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



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



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


Got it - thanks so much!

"Graham Mayor" wrote:

It is the correct one, but you have not interpreted it correctly. Note the
extra field brackets {} inserted with CTRL+F9 around the whole.
This is a calculated field surrounding the mergefield.
--

Graham Mayor - Word MVP

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



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




  #8   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Susan May Susan May is offline
external usenet poster
 
Posts: 13
Default How do I use field codes to format a number into currency?

Doug - I just tried to do this and it didn't work. My field codes look like
this

{MERGEFIELD "Sale" \"$,0.00; ($,0.00)"} and it doesn't change the format of
the number that I'm importing from Excel. What am I doing wrong?

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




  #9   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Susan May Susan May is offline
external usenet poster
 
Posts: 13
Default How do I use field codes to format a number into currency?

Doug, I kept searching for more answers and found the same information and
tried it again, and it worked.

Thanks - no need to reply back.

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




  #10   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default How do I use field codes to format a number into currency?

Change
{MERGEFIELD "Sale" \"$,0.00; ($,0.00)"}
to
{MERGEFIELD "Sale" \# "$,0.00; ($,0.00)"}

--

Graham Mayor - Word MVP

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



Susan May wrote:
Doug - I just tried to do this and it didn't work. My field codes
look like this

{MERGEFIELD "Sale" \"$,0.00; ($,0.00)"} and it doesn't change the
format of the number that I'm importing from Excel. What am I doing
wrong?

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





  #11   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default How do I use field codes to format a number into currency?

As posted, there is a "#" missing from your field code - you have

{MERGEFIELD "Sale" \"$,0.00; ($,0.00)"}

and you need

{MERGEFIELD "Sale" \#"$,0.00; ($,0.00)"}


Peter Jamieson

http://tips.pjmsn.me.uk

Susan May wrote:
Doug - I just tried to do this and it didn't work. My field codes look like
this

{MERGEFIELD "Sale" \"$,0.00; ($,0.00)"} and it doesn't change the format of
the number that I'm importing from Excel. What am I doing wrong?

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



  #12   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Susan May Susan May is offline
external usenet poster
 
Posts: 13
Default How do I use field codes to format a number into currency?

Peter - I just checked my code and I guess with all my queries out there last
Friday, I must have found the right syntax because I have the # sign in there
now.

Thanks so much for the clarification. I was so happy to see that it worked
before I went home on Friday. Love it when things work.

Again, thanks everybody for all your continued support. I don't know what
I'd do without my MS Tech group.

Susan May

"Peter Jamieson" wrote:

As posted, there is a "#" missing from your field code - you have

{MERGEFIELD "Sale" \"$,0.00; ($,0.00)"}

and you need

{MERGEFIELD "Sale" \#"$,0.00; ($,0.00)"}


Peter Jamieson

http://tips.pjmsn.me.uk

Susan May wrote:
Doug - I just tried to do this and it didn't work. My field codes look like
this

{MERGEFIELD "Sale" \"$,0.00; ($,0.00)"} and it doesn't change the format of
the number that I'm importing from Excel. What am I doing wrong?

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



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Field codes: MergeField field RTF format problem Amdious Mailmerge 4 September 17th 07 02:38 PM
Conditional Currency/Text Field Format in Merge Suzamo Mailmerge 3 March 14th 07 11:06 AM
Access currency field wont format correctly in word mail merge Marnee Mailmerge 3 June 2nd 05 05:40 AM
Currency fields in Access lose th currency format whn merged why PMasters Mailmerge 1 June 1st 05 08:13 PM
How do I format a merge field as Currency or %? hmj3b5 Mailmerge 1 February 22nd 05 08:07 AM


All times are GMT +1. The time now is 08:57 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"