Mail Merge - Thousand separators & Decimals




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.


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