Re: Help-doing mail merge between excel & word brings 8-9 extra nos

In article <E37FE176-2F29-4402-BBE1-8F5184D4C4F4@[EMAIL PROTECTED]
>,
 warbara <warbara@[EMAIL PROTECTED]
> wrote:

> I use 2003 word and excel; in doing a mail merge using excel spreadsheet
as 
> the data source, I merged vacation and PTO accruals and totals into word

> table and have tried to format the cells as general, text, custom and it

> still brings over about 8 numbers after the decimal and only way to get
rid 
> of them is to go in each cell of table and delete.  Am under deadline to

> finish these for 3 of our divisions and want to be able to clean this up

> without doing it manually in each cell.  Please help!

While you've landed in a Macintosh Excel newsgroup (hence the ".mac." in 
the group name, it's the same for Win or Mac.

You have three options.

   1) Use DDE
   2) Edit the Field Codes in Word
   3) Format the numbers as Text in XL

I generally prefer the second method as it works in all versions of 
Word/XL. For instance, try


      { MERGEFIELD "Accruals" \# 0.0 }