| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merge from Excel to Word Document
For some reason when I merge data from excel to a word document it is adding
extra info that I don't want. I checked my cell format and it is the way I want it. Example one of my fields includes a date when I merge it into word it has the date and time. It is also adding a .0 to other numbers. Any ideas??? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Merge from Excel to Word Document
In your word document, right click on the merge date field and add the
following format mask: \@ "dddd, MMMM d, yyyy" For currency add the following Numeric Pictu \# $#,##0.00 -- Kevin Backmann "AB" wrote: For some reason when I merge data from excel to a word document it is adding extra info that I don't want. I checked my cell format and it is the way I want it. Example one of my fields includes a date when I merge it into word it has the date and time. It is also adding a .0 to other numbers. Any ideas??? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Merge Excel charts into Word document | Excel Discussion (Misc queries) | |||
| How can I do a mail merge w/ Excel contacts into a Word document? | Excel Discussion (Misc queries) | |||
| How do I attach an excel document to a word one for mail merge? | Excel Discussion (Misc queries) | |||
| How do I merge excel information with a word document? | New Users to Excel | |||
| Excel format changes as I merge into Word document How can I stop | Excel Discussion (Misc queries) | |||
Linear Mode
