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

W

warbara

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!
 
J

JE McGimpsey

warbara said:
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!
Click to expand...

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 }
 
Top