Insert a decimal aligned tab stop and preceed the mergefields containing the
numbers with a tab space.
Alternatively, depending upon the layout of your maindocument in may be
possible to insert the mergefields into the cells of table that have the
paragraph alignment set to be right aligned.
Also see "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at
http://www.gmayor.com/formatting_word_fields.htm
for how to "preserve" the formatting that you are seeing in Excel.
--
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
"Jason.Bradley" wrote in message
...
So in excel numbers are formated to the right automatically which is nice,
but in word when merged, they become formated left to right. As a result
I'm
getting the data in the format of:
$ 320.57
$ 5.00
$ 81,000.00
my boss however would like to see this format instead:
$ 320.00
$ 5.00
$ 81,000.00
is it possible to do this safely and easily? I assume there is some sort
of
a "align right" that I can use on the field I'm merging?? Thanks! :-)