L
luisyana
While attempting to export a Notes view to Excel, save a revised Excel
worksheet, and merge the remaining fields into a Word document, we
encountered a situation where the zip code formatting in Excel was not coming
across into Word. This only presents a problem when the leading digit is a
zero (as in most of the states in the Northeast).
After reviewing the application Help information, and also pursuing it on
the Web, we did come across the following statement:
Format merged data
To format merged data, you must format the merge fields in the main
document. Don't format the data in the data source, because its formatting
isn't retained when you merge the data into the document.
1. In the main document, select the field containing the information you
want to format, including the surrounding merge field characters («« »»).
2. On the Format menu, click Font, and then select the options you want.
Because our source has both 5- and 9-digit zip codes, and each format has
leading zeroes, it's a bit of a problem. Particularly since the font options
don't allow numerical formatting.
The issue is: what is the best way to format a mixed 5- and 9-digit zip
code column of data when importing through the Excel wizard so that the same
field will display leading zeroes when used in a Word mail merge?
worksheet, and merge the remaining fields into a Word document, we
encountered a situation where the zip code formatting in Excel was not coming
across into Word. This only presents a problem when the leading digit is a
zero (as in most of the states in the Northeast).
After reviewing the application Help information, and also pursuing it on
the Web, we did come across the following statement:
Format merged data
To format merged data, you must format the merge fields in the main
document. Don't format the data in the data source, because its formatting
isn't retained when you merge the data into the document.
1. In the main document, select the field containing the information you
want to format, including the surrounding merge field characters («« »»).
2. On the Format menu, click Font, and then select the options you want.
Because our source has both 5- and 9-digit zip codes, and each format has
leading zeroes, it's a bit of a problem. Particularly since the font options
don't allow numerical formatting.
The issue is: what is the best way to format a mixed 5- and 9-digit zip
code column of data when importing through the Excel wizard so that the same
field will display leading zeroes when used in a Word mail merge?