Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

How format number fields in a mail merge document

Posted on 2014-01-29
1
Medium Priority
?
570 Views
1 Endorsement
Last Modified: 2014-02-01
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
Comment
Question by:SteveL13
1 Comment
 
LVL 76

Accepted Solution

by:
GrahamSkan earned 2000 total points
ID: 39819370
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

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you work with Word a lot, you probably use styles. If you use styles a lot, you've probably balled your fist more often than not when working with the ribbon. In Word 2007/2010, one of the things that I find missing when using styles is a quic…
Nice table. Huge mess. Maybe this was something you created way back before you figured out tabs or a document you received from someone else. Either way, using the spacebar to separate the columns resulted in a mess. Trying to convert text to t…
In this video, we show how to convert an image-only PDF file into a PDF Searchable Image file, that is, a file with both the image (typically from scanning) and text, which is created in an automated fashion with Optical Character Recognition (OCR) …
This video shows the viewer how to set up and create Footnotes in their document. Click on the References tab: Select "Insert Footnote": Type in desired text:
Suggested Courses

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question