Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
In XP how do I merge Word doc with Excel list and email? | New Users to Excel | |||
Link excel and word in mail merge without losing your data source? | Excel Discussion (Misc queries) | |||
Excel format changes as I merge into Word document How can I stop | Excel Discussion (Misc queries) | |||
EXCEL Decimal changes during WORD Merge | Excel Discussion (Misc queries) |