Reply
 
Thread Tools Display Modes
  #1   Report Post  
tony
 
Posts: n/a
Default Currency in merge from Excel

Excel data source contains a column with currency values (e.g. $10,000).
When used as data source for merge in Word, merge results in 10000. Loses
all currency formatting. We can add $ character, naturally, but how to get
the commas in there??? Better yet, how about, "How do you get Word to import
currency as currency, so you don't have to add a bunch of formatting that
should already be there???" Any thoughts / help much apprciated.
  #2   Report Post  
Beth Melton
 
Posts: n/a
Default

You can add a numeric switch to the mail merge field or use a
different method to connect to your Excel data source that will also
carry over the formats. Go to Tools/Options/General and turn on
"Confirm conversion at open". Then select your Excel data source again
and when prompted use the DDE method instead of OLE DB.

--
Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/


"tony" wrote in message
...
Excel data source contains a column with currency values (e.g.
$10,000).
When used as data source for merge in Word, merge results in 10000.
Loses
all currency formatting. We can add $ character, naturally, but how
to get
the commas in there??? Better yet, how about, "How do you get Word
to import
currency as currency, so you don't have to add a bunch of formatting
that
should already be there???" Any thoughts / help much apprciated.



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
Trailing zeros cut off on mail merge from Excel alant Mailmerge 2 January 21st 05 01:45 AM
How do I merge an excel document Pat McGlamery Tables 1 December 10th 04 03:00 AM
merge with excel question Cowtoon Mailmerge 1 December 7th 04 10:51 AM
Merge from Excel to word for labels pattimelt Mailmerge 1 December 5th 04 10:44 AM
Mail merge error occurs when filtering Excel data source Dave Mailmerge 1 December 2nd 04 10:46 PM


All times are GMT +1. The time now is 12:00 PM.

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

About Us

"It's about Microsoft Word"