#1   Report Post  
blanco
 
Posts: n/a
Default Mailmerge

I am merging numbers from Excel into a Word document. When merged, there is
a space after each number (123,456 ). There is not an extra space in the
Word merge doc. before nor after the merge field, nor is there a space after
the number in the Excel worksheet. For the numbers that are supposed to show
as negative numbers, the mergefield is between beginning parenthesis and end
parenthesis (mergefield 2). Because of the extra space, when merged there is
a space before the end parenthesis. How do I fix this?
--
Blanco
  #2   Report Post  
Cindy M -WordMVP-
 
Posts: n/a
Default

Hi ?B?YmxhbmNv?=,

I am merging numbers from Excel into a Word document. When merged, there is
a space after each number (123,456 ). There is not an extra space in the
Word merge doc. before nor after the merge field, nor is there a space after
the number in the Excel worksheet. For the numbers that are supposed to show
as negative numbers, the mergefield is between beginning parenthesis and end
parenthesis (mergefield 2). Because of the extra space, when merged there is
a space before the end parenthesis.

Which version of Word is involved, here? Did you choose a data connection
method, or let Word use its default?

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
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
MailMerge Word 2003 to Access 2000 query blank data BCool Mailmerge 1 January 15th 05 12:31 AM
Mailmerge in Word, date format in merged doc brownsox Mailmerge 2 January 14th 05 12:29 PM
Included Property in Word 2003 MailMerge Alessio Mailmerge 1 December 23rd 04 11:26 AM
Using MAILMERGE fields within HYPERLINK fields for Merge to Email Mark V Mailmerge 2 December 4th 04 04:01 PM
mailmerge wizard locator dlvery Mailmerge 1 December 4th 04 04:01 PM


All times are GMT +1. The time now is 11:22 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"