Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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) |