View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Kevin B Kevin B is offline
external usenet poster
 
Posts: 1,316
Default 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???