Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging from Excel to Word
When I merge dollar amounts from Excel to Word they come up with numbers like
$4,000.99999999999999999999. I would like them to come up with just places. How do you do that? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging from Excel to Word
Saved from a previous post:
Lots of times, it's easier to use MSWord for printing and Excel (or some other database application) as the source. You may want to read some tips for mailmerge. http://www.mvps.org/dmcritchie/excel/mailmerg.htm http://www.mvps.org/word/FAQs/MailMerge The first is from David McRitchie and the second is by Beth Melton and Dave Rado. And if you notice problems with the formatting of data (like zipcodes)... Debra Dalgleish posted this: There's an article on the Microsoft web site that might help you: Answer Box: Numbers don't merge right in Word http://office.microsoft.com/en-ca/as...164951033.aspx And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill has instructions he http://sbarnhill.mvps.org/WordFAQs/C...ngWord2002.htm about half way down the page. ========== I often cheat instead of racking my brain. I'll insert another column (probably hidden!) and use: =text(a2,"ddmmyy") or =text(a2,"mm:ss.0") or =text(a2,"00000") (or whatever format I want) and use that field in the mailmerge. (Cheating doesn't bother me anymore <vbg.) Barbara wrote: When I merge dollar amounts from Excel to Word they come up with numbers like $4,000.99999999999999999999. I would like them to come up with just places. How do you do that? -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging from Excel to Word
Try using the FIXED or TEXT Function in an adjacent cell and pull the data
from that cell. Micky "Barbara" wrote: When I merge dollar amounts from Excel to Word they come up with numbers like $4,000.99999999999999999999. I would like them to come up with just places. How do you do that? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merging documents with Word and Excel | Excel Discussion (Misc queries) | |||
Merging excel into word | Excel Discussion (Misc queries) | |||
how to keep excel formatting when merging to word? | Excel Discussion (Misc queries) | |||
Merging from Excel to Word | Excel Discussion (Misc queries) | |||
Excel/Word merging format pb | Excel Discussion (Misc queries) |