Merge with Excel

T

Tim S

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

Graham Mayor

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.

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
K

KR

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Mail Merge Directory Conditional Page Break 0
Merging from an Excel file with graphics 1
Merge Excel file into Word Document 3
How to count the numbers in a Word document? 0
Page numbering with Merged Document and IF statements 1
Start a mail merge upon opening the document 1
Paste / Hyperlink multiple Excel Spreadsheets to a Mail Merge Excel Source Document 0

Top