Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 212702 - Last Review: January 24, 2007 - Revision: 1.3
Date and number formats change during mail merge in Publisher
This article was previously published under Q212702
If you use a database that contains dates or numbers as the data
source for a Publisher mail merge, those dates or numbers may have a
different format in Publisher than in the program that created the
database. For example, you have cells in a Microsoft Excel Workbook
that appear to contain the following data:
January 1, 1996 $3.25 98025-1234
The data may appear like this in your merged publication:
Alternatively, if you enter numbers that contain leading zeros or ending zeros, they will be ignored during the Publisher mail merge. This occurs if the leading and ending zeros appear correctly in Microsoft Excel. The example below is a zip code for Boston, MA and for currency amounts:
The data may appear like this in your merged publication:
Many database and spreadsheet programs use input masks to control how
data appears when you view it on screen. In Microsoft Excel, for example,
if you type some data in a date format (such as 1/1/96) or a number format
(such as 02110), Microsoft Excel automatically applies an input mask to
make that data appear as January 1,1996. The actual number that is saved in
the workbook is 1/1/96, Microsoft Excel changes the appearance of the data
dynamically.
Input masks are part of the source application, not the database file
itself. When you use a database as a data source in Publisher,
Publisher receives the raw data without the input masks.
All versions of Microsoft Excel for Windows, and Microsoft Access for Windows use input masks and exhibit the symptoms described in this article.
Most programs that create databases and spreadsheets have a feature
to save as a delimited text file. If you export a database or
spreadsheet as a text file, the text file contains the result of the
input masks, not the raw data.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
APPLIES TO
- Microsoft Office Publisher 2003
- Microsoft Publisher 2002 Standard Edition
- Microsoft Publisher 2000 Standard Edition
- Microsoft Publisher 98 Standard Edition
| kbinterop kbmerge kbprb KB212702 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate