• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 583
  • 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

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

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