mail merge problem

[er]

Hi All,

i have a excel file. one cell i set the format is currency with 2 decimal
places.
so, if i type 1000.678, then in this cell, it should be show 1000.68. it is
ok and normal in this excel file.
but, i have another word file which want to do mail merge and link this
excel.
i found that after i did the merge, the value will show 1000.678 but not
1000.68. it seem mail merge didnt use two decimal places.
how can i fix it? thx a lot

 

[David Heaton]

Hi All,

i have a excel file. one cell i set the format is currency with 2 decimal
places.
so, if i type 1000.678, then in this cell, it should be show 1000.68. it is
ok and normal in this excel file.
but, i have another word file which want to do mail merge and link this
excel.
i found that after i did the merge, the value will show 1000.678 but not
1000.68. it seem mail merge didnt use two decimal places.
how can i fix it? thx a lot

check this site out for word field code help

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

regards

David

 

[er]

actually i dont know what this web page said, coz i am not expert in excel.
anyway thx

 

[Dave Peterson]

Debra Dalgleish posted this:

There's an article on the Microsoft web site that might help you:

Answer Box: Numbers don't merge right in Word
http://office.microsoft.com/en-ca/assistance/HA011164951033.aspx

And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill
has instructions here:

http://sbarnhill.mvps.org/WordFAQs/CustomizingWord2002.htm

about half way down the page.

==========
I often cheat instead of racking my brain.

I'll insert another column (probably hidden!) and use:
=text(a2,"ddmmyy")
or
=text(a2,"mm:ss.0")
or
=text(a2,"00000")
(or whatever format I want)
and use that field in the mailmerge.

(Cheating doesn't bother me anymore <vbg>.)

 

[Forgone]

Changing the number format in excel will not change the merge field in MS
Word.

In MS Word, you need to edit the word field and add a switch so that it
would format the number in the manner you want.
EG: a field called "Total Price" is $999.99999 but you want to show $999.99
thus in the "Total Price" mergefield in MS Word you will need to add a
switch.... EG: when displaying the field codes... you will see

{ MERGEFIELD Total_Cost }

You need to change this too { MERGEGIELD Total_Cost \# "$0.00" } so that it
will display correctly.