Hi,
I was trying to use the mail merge function for drafting
letters. I am using an excel spreadsheet as a data source
for this merge. However, when I perform mail merge, the
formatting of currency and numbers do not appear as it
does in the spreadsheet.
For example,
$26,000.00 would appear in the merged document as $26000
and numbers like 26,000 would appear as 26000
I need to retain the original formatting or else I would
have to edit each page manually. Can someone please help
me? Thanks in advance.
-Anny
Cindy M -WordMVP- - 03 Dec 2003 18:52 GMT
Hi Anny,
May we assume this is Word 2002 or 2003? See the Word 2002
section in my website's mail merge FAQ, plus the information
on formatting. To summarize: you can either change the way
you link to the Excel data, or add numeric formatting
switches to the merge fields.
> I was trying to use the mail merge function for drafting
> letters. I am using an excel spreadsheet as a data source
[quoted text clipped - 6 lines]
>
> and numbers like 26,000 would appear as 26000
Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
http://www.mvps.org/word
This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail :-)