Mail Merge - Thousand separator and decimals


C

cocomin

Hi,

I have a problem with mail merge. When I tried to merge the figures (with
thousand separator and decimals) in the excel file to the word doc, the
thousand separator and decimal points cannot be displayed when the cells in
Excel has been formatted as currency, with up to 2 decimal points.

As my excel file contains formula, thus I am not able to save the file as
tab delimited.

Any idea how to retain the formatting in excel (ie. field to be in currency
with up to 2 decimal palce) while the thousand separators and decimals can be
displayed in the word doc when doing mail merging?

Just to highlight that I'm using Microsoft Office 2003.

Many thanks.
 
Ad

Advertisements

D

Dave Peterson

Debra Dalgleish posted this:

There's an article on the Microsoft web site that might help you:

Answer Box: Numbers don't merge right in Word
http://office.microsoft.com/en-ca/assistance/HA011164951033.aspx

And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill
has instructions here:

http://sbarnhill.mvps.org/WordFAQs/CustomizingWord2002.htm

about half way down the page.

==========
I often cheat instead of racking my brain.

I'll insert another column (probably hidden!) and use:
=text(a2,"ddmmyy")
or
=text(a2,"mm:ss.0")
or
=text(a2,"00000")
(or whatever format I want)
and use that field in the mailmerge.

(Cheating doesn't bother me anymore <vbg>.)
 

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

Top