View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
 
Posts: n/a
Default Formatting a Mail Merge Field

That would have to be the most commonly asked question in this newsgroup and
about 30 seconds of browsing earlier questions and the answers to them would
have given you the information that you need.

Anyway, three and half hours later, here it is:

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

"Angela" wrote in message
...
We are trying to to do a maint increase letter. So we have a letter and
there are certain fields coming from excel. So we have a field that is
'increased amount'. In excel it is formatted in numeric with only two
decimal places. (We have also tried formatting the excel fields in
currency,
two decimal points).
The office manager does what she needs to do to merge, but the increased
amount field comes up with "$24.36589452" We only need two decimal
places.
How can I format the field so it will print properly. I have tried
looking
at the help notes and have not been successful. This is maddening, so if
someone would help me, I would greatly appreciate it.

Thank you in advance,
Angela