Merge from Excel to Word Document

[Guest]

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???

 

[Guest]

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 Picture:

\# $#,##0.00