Source Data in Excel Format

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Phyllis - 05 Nov 2007 21:25 GMT

In Word 2003, my source document has numbers, in excel I used the format I
want, but when bringing in the excel spreadsheet to Word mail merge its
adding a million zero's to field that only orginally went 2 places beyond the
decimal. How do I get the merge doc. to only show 2 places past the decimal?

Reply to this Message

Phyllis - 05 Nov 2007 22:31 GMT

I figured it out...there was a document on the online help that basically
told me to reformat the merge code by pressing alt f9 and adding to the
source code \# "###.##" to keep it from displaying 105.010000000000001 (for
example). But if anyone finds another way, please chime in, I'll be watching
out for it.

> In Word 2003, my source document has numbers, in excel I used the format I
> want, but when bringing in the excel spreadsheet to Word mail merge its
> adding a million zero's to field that only orginally went 2 places beyond the
> decimal. How do I get the merge doc. to only show 2 places past the decimal?

Reply to this Message

Doug Robbins - Word MVP - 06 Nov 2007 09:07 GMT

That is the way to do it. For more on the subject, see "Formatting Word
fields with switches" on fellow MVP Graham Mayor's website at:

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

Signature

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

>I figured it out...there was a document on the online help that basically
> told me to reformat the merge code by pressing alt f9 and adding to the
[quoted text clipped - 11 lines]
>> decimal. How do I get the merge doc. to only show 2 places past the
>> decimal?

Reply to this Message

DHinton - 09 Jan 2008 23:56 GMT

I have this same problem using Word 2002 and Excel 2002--Any ideas on how to
fix or please include the article you are referring to.

Reply to this Message

Rich/rerat - 10 Jan 2008 06:24 GMT

Phyllis & DHinton,
Try adding a switch to the Mergefield:

{ MERGEFIELD Value /# "0.00;(0.00)"}

More information on switches for MS Word can be found at::
http://www.gmayor.com/formatting_word_fields.htm

Signature

Add MS to your News Reader: news://msnews.microsoft.com
Rich/rerat
(RRR News) <message rule>
<<Previous Text Snipped to Save Bandwidth When Appropriate>>

I have this same problem using Word 2002 and Excel 2002--Any ideas on how to
fix or please include the article you are referring to.

"Phyllis" wrote:

> In Word 2003, my source document has numbers, in excel I used the format I
> want, but when bringing in the excel spreadsheet to Word mail merge its
> adding a million zero's to field that only orginally went 2 places beyond
> the
> decimal. How do I get the merge doc. to only show 2 places past the
> decimal?

Reply to this Message