Number format from excel data source

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lori IKEA - 14 Dec 2004 17:45 GMT

How do you get the number format from an Excel data source to translate into
a Word mail merge document in XP? It's taking the raw data (i.e., 9 decimal
places for a # from a formula instead the formatted 2)

Reply to this Message

macropod - 15 Dec 2004 10:14 GMT

Hi Lori,

Add a numeric picture switch to the mergefield. To do this, select the filed
and press Ctrl-F9 to reveal the code. It should look something like:
{MERGEFIELD ExcelData}
Edit it by adding a numeric picture switch thus:
{MERGEFIELD ExcelData \# ,0.00;-0.00}

You can also add currency symbols etc. For more information on this,
download the Word document at:
www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=365442
(url all one line)

Cheers

> How do you get the number format from an Excel data source to translate into
> a Word mail merge document in XP? It's taking the raw data (i.e., 9 decimal
> places for a # from a formula instead the formatted 2)

Reply to this Message