View Single Post
  #4   Report Post  
Cindy M -WordMVP-
 
Posts: n/a
Default

Hi ?B?QW5uIFNjaGFycGY=?=,

Yes, I was trying to avoid using switches because I know I will hear no end
of grief about how complicated Word is making things. (You know, the whole
"shoot the messenger" thing!)

Yeah, MS didn't make life any easier for the end-user with this new default
interface. Their hearts were in the right places, but they weren't listening
to the right people...

From what I'd read in other posts/links, I thought that EITHER the rounding
OR the DDE would fix the problem. I did not think I would have to do BOTH.

If you were using "normal numbers" with, say, just two decimal places, DDE
would work. The problem is that you want such a degree of accuracy, and with
computers there's always a bit of a discrepancy when it comes to lots of
decimal places.

Best thing for the user would probably be a button they can push in Excel to
"convert" the table to a mail merge data source (write the columns to a "temp"
sheet, and format them all as literal strings using the Data tools). Then it
won't matter which connection method they choose.

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