I have a complex spreadsheet with multiple calculations and am merging the
data into Word. When I run the merge, I lose all formatting of the numbers,
and about 10 decimal places print. I have added round functions to my
formulas, but still haven't completly solved the problem. How do I bring in
commas, dollar signs and only 2 decimal points when merging with Word?

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm


--
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

"slb" wrote in message
...
I have a complex spreadsheet with multiple calculations and am merging the
data into Word. When I run the merge, I lose all formatting of the
numbers,
and about 10 decimal places print. I have added round functions to my
formulas, but still haven't completly solved the problem. How do I bring
in
commas, dollar signs and only 2 decimal points when merging with Word?

Thank-you, I was having trouble getting the switches to work. I found the
following explanation which solved my problem and was easier. (I am working
in Office 2003). http://www.http://www.uwec.edu/help/...-withxls-m.htm


"Doug Robbins - Word MVP" wrote:

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm


--
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

"slb" wrote in message
...
I have a complex spreadsheet with multiple calculations and am merging the
data into Word. When I run the merge, I lose all formatting of the
numbers,
and about 10 decimal places print. I have added round functions to my
formulas, but still haven't completly solved the problem. How do I bring
in
commas, dollar signs and only 2 decimal points when merging with Word?

The link you posted referred to a different solution entirely. You could
have found that solution elsewhere on my web site. For the formatting of
Word fields the switch method is easier, so I am puzzled why you found it
difficult. If you coulkd explain your difficulty maybe I could improve the
page to make it more accessible.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


slb wrote:
Thank-you, I was having trouble getting the switches to work. I
found the following explanation which solved my problem and was
easier. (I am working in Office 2003).
http://www.http://www.uwec.edu/help/...-withxls-m.htm


"Doug Robbins - Word MVP" wrote:

See "Formatting Word fields with switches" on fellow MVP Graham
Mayor's website at

http://www.gmayor.com/formatting_word_fields.htm


--
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

"slb" wrote in message
...
I have a complex spreadsheet with multiple calculations and am
merging the data into Word. When I run the merge, I lose all
formatting of the numbers,
and about 10 decimal places print. I have added round functions to
my formulas, but still haven't completly solved the problem. How
do I bring in
commas, dollar signs and only 2 decimal points when merging with
Word?

[Dean]

Can you help me out. I have a similar problem with a mail merge and I can't
seem to use the web site you have indicated as my Word doesn't have the data
merge manager under tools. I can't solve the problem of reformatted my
numeric merge down to two decimal places. thanks for any assistance you can
provide.
my work email is
thanks again,
--
Dean


"slb" wrote:

I have a complex spreadsheet with multiple calculations and am merging the
data into Word. When I run the merge, I lose all formatting of the numbers,
and about 10 decimal places print. I have added round functions to my
formulas, but still haven't completly solved the problem. How do I bring in
commas, dollar signs and only 2 decimal points when merging with Word?

[Doug Robbins - Word MVP]

I am not sure to what web site you are referring. Was it "Formatting Word
fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm

Nor have you told us what version of Word you are using, not that it makes
any difference to the formatting of the fields, but as far as your problem
with the lack of what you refer to as "the data merge manager under tools"
on other pages on the above website you will find information on displaying
the mailmerge toolbar (ViewToolbars). Look at the page about merging to
labels with Word XP.

--
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

"Dean" wrote in message
...
Can you help me out. I have a similar problem with a mail merge and I
can't
seem to use the web site you have indicated as my Word doesn't have the
data
merge manager under tools. I can't solve the problem of reformatted my
numeric merge down to two decimal places. thanks for any assistance you
can
provide.
my work email is
thanks again,
--
Dean


"slb" wrote:

I have a complex spreadsheet with multiple calculations and am merging
the
data into Word. When I run the merge, I lose all formatting of the
numbers,
and about 10 decimal places print. I have added round functions to my
formulas, but still haven't completly solved the problem. How do I bring
in
commas, dollar signs and only 2 decimal points when merging with Word?

[Peter Jamieson]

Are you using Word for the Mac? If so, which version?

Peter Jamieson

"Dean" wrote in message
...
Can you help me out. I have a similar problem with a mail merge and I
can't
seem to use the web site you have indicated as my Word doesn't have the
data
merge manager under tools. I can't solve the problem of reformatted my
numeric merge down to two decimal places. thanks for any assistance you
can
provide.
my work email is
thanks again,
--
Dean


"slb" wrote:

I have a complex spreadsheet with multiple calculations and am merging
the
data into Word. When I run the merge, I lose all formatting of the
numbers,
and about 10 decimal places print. I have added round functions to my
formulas, but still haven't completly solved the problem. How do I bring
in
commas, dollar signs and only 2 decimal points when merging with Word?