Reply
 
Thread Tools Display Modes
  #1   Report Post  
Lori IKEA
 
Posts: n/a
Default Number format from excel data source

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)
  #2   Report Post  
macropod
 
Posts: n/a
Default

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:
http://www.wopr.com/cgi-bin/w3t/show...?Number=365442
(url all one line)

Cheers


"Lori IKEA" Lori wrote in message
...
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
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Word Field Codes in Excel data file mranz Mailmerge 7 December 11th 04 10:02 AM
Mailmerge wont see Added Excel Data source Columns Thatdampwood Mailmerge 3 December 2nd 04 11:56 PM
merging Word 2000 data source and word 2003 envelopes Jini Mailmerge 1 December 2nd 04 11:48 PM
Mail merge error occurs when filtering Excel data source Dave Mailmerge 1 December 2nd 04 11:46 PM
Merge Data Source path Peter Jamieson Mailmerge 0 November 25th 04 08:15 PM


All times are GMT +1. The time now is 06:18 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"