Merge with Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tim S - 16 Jul 2004 22:30 GMT

The field in Excel is a number with a comma but when
merged the comma is gone. Any help would be appreciated

Reply to this Message

Graham Mayor - 17 Jul 2004 06:50 GMT

Do you mean the thousands separator eg 15,000 is missing?
That being the case, you will have to replace the required format with a
switch - see http://www.gmayor.com/formatting_word_fields.htm
to make 15000 display as 15,000 the switch - \# ",#" will do the job.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> The field in Excel is a number with a comma but when
> merged the comma is gone. Any help would be appreciated

Reply to this Message

KR - 22 Jul 2004 12:23 GMT

Alternatively to the answer posted below. Launch Word. Go
to Tools; Options; General. Select Confirm conversion at
Open; OK. Follow the usual procedure to create your mail
merge. Once you have selected your data source, a dialog
box will appear. Select MS Excel Worksheets via DDE
(*.xls); OK. Proceed with the mail merge as before. When
you preview your individual letters, the numeric data will
retain the formatting as per the data source

>-----Original Message-----
>The field in Excel is a number with a comma but when
>merged the comma is gone. Any help would be appreciated
>.

Reply to this Message