View Single Post
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Angela
 
Posts: n/a
Default Formatting a Mail Merge Field

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