Mail merge problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Penny Smith - 10 Nov 2004 16:57 GMT

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?

Reply to this Message

Cindy M -WordMVP- - 10 Nov 2004 20:33 GMT

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
[quoted text clipped - 4 lines]
> 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 :-)

Reply to this Message