Article ID: 246066 - View products that this article applies to.
This article was previously published under Q246066
This article has been archived. It is offered "as is" and will no longer be updated.
When you print a Microsoft Works Word Processor document that contains merged database fields, the data in certain date, time, currency, phone number, or other formatted numeric fields may be printed as unformatted numbers.
This issue may occur if either of the following conditions is true:
To work around this issue, use your database or spreadsheet program to export the table you want to merge as a formatted text (.txt) file, and then insert fields from the exported text file into your Works Word Processor document.
-or-To work around this issue, create another field in the database which is formatted as text and filled with the contents of the original "problem" field, but use some built-in text functions to force the format to include the requisite dollar-sign ($) and appropriate 2 decimal places. To do this, follow these steps:
Note In the steps below, "PROBLEM_FIELD" refers to the field that will not merge correctly and "NEW_FIELD" refers to the field that you will create to carry the text data. Please substitute with the actual field names you wish to use.
Note The spaces are really important, (2 before Jan, 1 after Dec and 1 between each month).
=STRING(DAY(Date_field),0)&MID(" Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec ",MONTH(Date_field),5)&STRING(YEAR(Date_field)+1900,0)
This issue may also occur in Microsoft Word 2000, included in Microsoft Works Suite.
For more information about how to resolve this issue in Word 2000, click the following article number to view the article in the Microsoft Knowledge Base:
(https://support.microsoft.com/kb/211421/ )WD2000: Incorrect format of phone number in mail merge result
Article ID: 246066 - Last Review: February 28, 2014 - Revision: 6.1