ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Merge from Excel to Word Document (https://www.excelbanter.com/excel-discussion-misc-queries/157344-merge-excel-word-document.html)

AB

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

Kevin B

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



All times are GMT +1. The time now is 12:45 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com