View Single Post
  #3   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 Currency and Decimal Places..Am aware it has been answered.

I assume that you are referring to the "Formatting Word fields with
switches" on fellow MVP Graham Mayor's website at:

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

Assuming that you are talking about the output of a mailmerge operation, all
that you need to do is press Alt+F9 when the mailmerge main document is the
active document (that is before executing the merge) to display the field
codes and then to the field that you want to apply the formatting, insert
the formatting switch

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

inside the closing }

Note, if you do not have any negative values, you don't need the

;($,0.00)

part of the above, but it won't hurt to have it.

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

"Charlotte" wrote in message
...
Hi.
I'm having the same problem with most others regarding the decimal places
and currency transfer from Excel to Word.

I have read over the webpage detailing what you should do but I am totally
new to this system and did not understand much of it.

Could someone please explain how to resolve this problem in newbie terms
please?

Thank you.
Charlotte