Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 579
  • Last Modified:

How format number fields in a mail merge document

I have some number fields appearing in a mail merge document.  The data is coming from a MS Access database and in the database I have the fields formatted like xxx.xx (two decimals.

But in the mail merge document fields they appear as you see them in the attachment.

Somehow I want them to appear as number with two decimals and also appear flush right.

How do I do this?
MergeFields.jpg
1
SteveL13
Asked:
SteveL13
1 Solution
 
GrahamSkanRetiredCommented:
You can use Word field formatting switches.

Switch to field code view with the Alt+F9 toggle so that

<<MyField>>

looks like
{ MERGEFIELD MyField }

Then add the switch
{ MERGEFIELD MyField  \# ,#.00}
You can then use the toggle to hide the field codes again.

To flush right, select the cells and choose the alignment from the group in the Table Tools/Layout tab
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now