How do you convert a merge field to currency?

To format a numeric merge field, use the \# switches. For example, to display a currency field as “$125.23”, the merge field should be defined as {MERGEFIELD myObject. myField \# $#,##0.00} . To format a date merge field, use the \@ switches.

How do you format cells to currency in Word?

On the Home tab, click the Dialog Box Launcher next to Number. Tip: You can also press Ctrl+1 to open the Format Cells dialog box. In the Format Cells dialog box, in the Category list, click Currency or Accounting. In the Symbol box, click the currency symbol that you want.

How do I fix field codes in Word?

Ctrl + F9 inserts field braces. You can also enter the field code (the text) first, select it, and press Ctrl + F9 to enclose the text in field braces. Then, update by pressing F9.

How do I convert text to fields in Word?

Press Ctrl+Shift+F9. This converts the field to actual text.

How do you maintain currency format in a mail merge?

The solution to controlling the number and currency formatting of Excel data in Word is to add a numeric switch (previously called a picture switch) to the mail merge code or MERGEFIELD.

How do I change the format of a mail merge field?

Press [Alt] + F9 again. Position the cursor anywhere in this field and press the [F9] function key to update it. Or, right-click the field and choose Update Field. Preview the results to confirm the merge field displays with the formatting you want to see in the document for each of the mail merge records.

Can you format numbers in Word?

Word does not really have number formatting for table cells. You can align cell contents on the decimal point, though, by setting a so-called decimal tab stop.

How do I reveal codes in Word 2010?

Here’s how.

  1. To reveal the formatting symbols, go to the ribbon and select Home.
  2. In the Paragraph group, select Show/Hide (the icon looks like a paragraph mark).
  3. The formatting symbols appear in the document and each symbol is represented by a specific mark:
  4. To hide the formatting symbols, select Show/Hide.

What are field codes in Word?

What is a Field Code? A field code is “smart” text – when used, they can update when needed. There are hundreds of various codes for various purposes, one of the most common being the code for the current date – 29at24-Ti1824 Pictu24. Any time the field updates, the information within the field updates.

How do you show field codes?

You know you can use the Field Codes check box on the View tab of the Options dialog box to control whether or not field codes are displayed in your document. You may even know that you can use Alt+F9 to switch between field codes and their results.