View Single Post
  #8   Report Post  
Posted to microsoft.public.word.mailmerge.fields
seagull seagull is offline
external usenet poster
 
Posts: 4
Default When merging from excell, how do I keep $ and no decimal

Hi Doug ,

mean i jz update my field and add the switch once on my master file will
do rite ?

"Doug Robbins - Word MVP" wrote:

You do not have to do it monthly, you just do it the one time in the
mailmerge main document.

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

"seagull" wrote in message
...
HI...
I also facing this problem when doing the data merge due with no decimal ,
it can be solve by edit the field with the formating switch,

just wonder izzit any better solution to solve this , coz i will be
repeating doing this mail merge with different data every months , so it's
a
bit troublesome for me to edit my field one by one ,monthly ....





"Doug Robbins - Word MVP" wrote:

Press Alt+F9 to toggle on the display of the field codes and inside the
closing } at the following formatting switch:

\# "$,0"

For more information, see "Formatting Word fields with switches" on
fellow
MVP Graham Mayor's website at
http://www.gmayor.com/formatting_word_fields.htm


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

"Shelly Reiff" Shelly wrote in message
...
I am trying to merge an Excell spreadsheet into Word. One of my
columns,
is
a computed figure title Total Contact. In Word, I want the number to
be
in
this format: $30,800. I can only get it to print in this format
30800.25.
How do I do this?