Mail Merge - Thousand separators & Decimals

[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.

 

[David Biddulph]

Either use Word's DDE or field formatting (linked from
http://word.mvps.org/FAQs/MailMerge/), or in Excel use
=TEXT(your_formula,"£#,##0.00") .

See also http://www.mvps.org/dmcritchie/excel/mailmerg.htm,
http://office.microsoft.com/en-gb/word/HA011164951033.aspx, or
http://sbarnhill.mvps.org/WordFAQs/CustomizingWord2002.htm .