Mail merge problem

[Penny Smith]

I want the Word Doc to show the answer in the reference Doc's cell, not the
formula and I want it show go out 8 decimal places just like the answer in
Excel sheet does. The Word Doc shows it as .5649877000000000E7 instead of
..56498770

Is there a switch or something that can be added to the Word Doc so it shows
it properly? And how do you add the switches. I know about Alt+F9 to show
merge format, but do you add the switch after the Data in the field?

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?UGVubnkgU21pdGg=?=,

Your question isn't quite clear. Which version of Word are we dealing with? And
is the data source in Excel, or in Word?

I want the Word Doc to show the answer in the reference Doc's cell, not the
formula and I want it show go out 8 decimal places just like the answer in
Excel sheet does. The Word Doc shows it as .5649877000000000E7 instead of
..56498770

Is there a switch or something that can be added to the Word Doc so it shows
it properly? And how do you add the switches. I know about Alt+F9 to show
merge format, but do you add the switch after the Data in the field?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail