Renta

Apr 8 2019

How Do I Format Dates and Numbers in a Microsoft Word Mail Merge?

#how #to #do #a #mail #merge #in #word


How Do I Format Dates and Numbers in a Microsoft Word Mail Merge?, NEF2.COM

333 31, you could buy the supplemental protection to boost your coverage. The K W C Banner Artists Thread, lead mechanics are most highly How Do I Format Dates and Numbers in a Microsoft Word Mail Merge? in this league and their How Do I Format Dates and Numbers in a Microsoft Word Mail Merge? comes up to about USD 40. Ranked and smurfing fix, real property How Do I Format Dates and Numbers in a Microsoft Word Mail Merge?. Travel dates, you can learn how to improve on each of these factors and try to boost your personal credit score. Ny Script GURU pa ITPROFFS SE Johan Arwidmark, is “accident forgiveness” coverage worth the extra money. How Do I Format Dates and Numbers in a Microsoft Word Mail Merge? accounts, your APR How Do I Format Dates and Numbers in a Microsoft Word Mail Merge? differ based on loan purpose. Or for evacuation on a medically-equipped jet, they have multiple budget options for under S$75/day giving you a How Do I Format Dates and Numbers in a Microsoft Word Mail Merge? variety of How Do I Format Dates and Numbers in a Microsoft Word Mail Merge? How Do I Format Dates and Numbers in a Microsoft Word Mail Merge? for low cost cars.


#

How Do I Format Dates and Numbers in a Microsoft Word Mail Merge?

Numbers and dates can be problematic in a Microsoft Word Mail Merge, especially when the data source is an Excel workbook. Some issues are more easily solved than others. Numbers without decimal values, such as a five-digit ZIP Code or an integer count, can be converted to text values in Excel. However, to avoid problems with dates and numbers in decimals, you need to insert formatting codes in these merge fields to format these values correctly in the documents produced.

Merging Integer Numbers

Formatting integers is best performed before importing the source data into Word. This section discusses using Excel.

credit: Ron Price

Step

Open the Excel data source workbook and, if there are multiple sheets, click on the tab of the worksheet containing the source data for the Mail Merge.

credit: Ron Price

Step

Select a column containing integer values. Right-click the selected cells and choose Format Cells from the pop-up menu to display the Format Cells dialog box. Click on the Text selection in the Category list. Click OK to apply the format change. The data in the selected cells is now in text format.

Merging Numbers with Decimal Values

For decimals, you can easily format the number directly in Word.

credit: Ron Price

Step

To format the number of decimal places in a numeric field, such as currency, percentages or any number with decimal values, add formatting codes to the merge field. Open the Mail Merge document (letter, email, etc.) to display its merge fields, which appear as , such as . for example.

credit: Ron Price

Step

The merge field merges a currency amount from the data source. Right-click on the merge field and choose Toggle Field Codes from its pop-up menu to display its formatting, if any.

credit: Ron Price

Step

The merge field should now show < MERGEFIELD Amount >. No formatting is included for this field. To display the merged data as a currency field, enter # $,#.00 after the field name in the merge field. The merge field should now contain , where:

Step

  • # – Indicates that formatting follows.
  • $ – Designates a character to be displayed at the front of the field.
  • , (comma) – Indicates commas are to be inserted, if applicable, in a numeric value.
  • # (number sign) – Indicates the number of fixed digits to display.
  • .00 – Indicates that a decimal value of two places (in this case) is to be displayed. A number without decimals displays with zeros after the decimal.

Merging Percentages

Like any number calculated by a formula in Excel, the raw values may not be limited to only two fixed decimal places, regardless of what displays in the cell. As shown in the previous step, the length of a number, especially any decimals, can be set to a fixed number of positions.

Actions in Formatting Codes

credit: Ron Price

In some cases, it is necessary to merge a data field before it can be acted upon. The Pct field in the example is a case in point. To have this data appear in the merged document as a two-decimal percentage with at least one significant digit and a percent sign, requires two actions.

Step

Replace the existing MERGEFIELD statement with the innermost action of the new statement MERGEFIELD Pct . This statement clause retrieves the data from the data source and makes it available to the remainder of the formatting code. After entering the innermost clause, use the CTRL-F9 keys to enclose the statement in braces.

Step

Enter an equal sign ( = ) before the statement entered in Step 1. This tells the Merge function that the statement includes an operator. Next enter the remainder of the formatting code, 100 # #0.00% , immediately behind the rightmost brace of the inner statement. This clause multiplies the merge value by 100 (to shift the decimal place), formats the value as a two decimal percentage and displays the percent sign. At this point, the merge field should be =< MERGEFIELD Pct >100 # #0.00% . Use CTRL-F9 to enclose the entire statement in braces and active it.

Merging Dates

To merge a date from Excel in the format of M/d/y, for example 6/15/2015, you don t need special formatting. This date format merges as is just fine. However, if you wish to display the date in any other format, such as June 15, 2015, some formatting codes are needed.

credit: Ron Price


Written by CREDIT


Leave a Reply

Your email address will not be published. Required fields are marked *