Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Curt in Virginia
 
Posts: n/a
Default Currency merge from Excel to Word

I have currency formatted numbers in a column that I merge into a Word
document. When I do the merge, the $ sign, comma and period do not follow
into the word document. What am I doing wrong?
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjobom
 
Posts: n/a
Default Currency merge from Excel to Word

Are you talking about mailmerge? Make the currency values text

=TEXT(A1,"$#,##0.00")

then copy and paste special over the old values and then delete any help
cells where you put the formula, then try to mailmerge

http://word.mvps.org/FAQs/MailMerge/index.htm

all you need to know including "force word to use the number format you
want"

--

Regards,

Peo Sjoblom

Nothwest Excel Solutions

www.nwexcelsolutions.com

remove ^^ from email

"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"Curt in Virginia" <Curt in wrote in
message ...
I have currency formatted numbers in a column that I merge into a Word
document. When I do the merge, the $ sign, comma and period do not follow
into the word document. What am I doing wrong?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
In XP how do I merge Word doc with Excel list and email? macinga New Users to Excel 1 January 12th 06 03:39 PM
Link excel and word in mail merge without losing your data source? angie Excel Discussion (Misc queries) 5 July 1st 05 06:29 PM
Excel format changes as I merge into Word document How can I stop AngieDerbyshire Excel Discussion (Misc queries) 1 January 8th 05 12:19 AM
EXCEL Decimal changes during WORD Merge svlm Excel Discussion (Misc queries) 1 January 5th 05 04:33 PM


All times are GMT +1. The time now is 09:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"