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