/
How to Merge Numeric or Currency Fields as Text

How to Merge Numeric or Currency Fields as Text

You can use Microsoft Word fields to convert data from SmartAdvocate merge codes.

  1. Insert field from the Word toolbar.

  2. Press Alt-F9 if the field is not visible (you can press it again to hide field codes and show values).

  3. Insert desired merge code after = sign and replace MERGEFORMAT with desired formatting options. Below example will format settlement about as dollar text and capitalize first letter.

  4. Refer to below tables for additional formatting options.

Format (\*) fieldswitch

The following is a list of switches and items that they capitalize:

\* Caps

The first letter of each word.

For example, { FILLIN "Type your name:" \* Caps } displays "Graham Mayor" even if the name is typed in lowercase letters - graham mayor.

Note: Where the text to be formatted is in uppercase, the \*Caps switch may appear to do nothing. In this case first convert the content to lower case by using the \*Lower switch thus:

{ MERGEFIELD Name \*Lower \*Caps }

\* FirstCap

The first letter of the first word.

For example, { COMMENTS \* FirstCap } might display "Weekly report on sales". 

Note: See also the previous section concerning the anomaly where the underlying text is formatted as all caps.

\* Upper

All letters are upper case

For example, { QUOTE "word" \* Upper } displays "WORD".

\* Lower

All letters are lowercase.

For example, { FILENAME \* Lower } displays "weekly sales report.doc". 

Note: This switch has no effect if the entire field that contains the switch is formatted as small capital letters.

 

Number formats

The following is a list of number switches and their results:

\*alphabetic

Displays results as alphabetic characters. The result has the same case as the word "alphabetic" in the switch.

For example, { SEQ appendix \* ALPHABETIC } displays "B" (instead of "2"), and { SEQ appendix \* alphabetic } displays "b".

\*Arabic

Displays results as Arabic cardinal numerals.

For example, { PAGE \* Arabic } displays "31". 

Note: If the Number format setting in the Page Number Format dialog box (Page Numbers command, Insert menu) is not Arabic, this switch overrides the Number format setting.

\*CardText

Displays results as cardinal text. The result is formatted in lowercase letters unless you add a format switch to specify a different capitalization.

For example, { = SUM(A1:B2) \* CardText } displays "seven hundred ninety", and { = SUM(A1:B2) \* CardText \* Caps } displays "Seven Hundred Ninety".

\*DollarText

Displays results as cardinal text. Microsoft Word inserts "and" at the decimal place and displays the first two decimals (rounded) as Arabic numerators over 100. The result is formatted in lowercase letters unless you add a format switch to specify a different capitalization.

For example, { = 9.20 + 5.35 \* DollarText \* Upper } displays "FOURTEEN AND 55/100".

\*Hex

Displays results as hexadecimal numbers. For example, { QUOTE "458" \* Hex } displays "1CA".

\*OrdText

Displays results as ordinal text. The result is formatted in lowercase letters unless you add a format switch to specify a different capitalization.

For example, { DATE \@ "d" \* OrdText } displays "twenty-first", and { DATE \@ "d" \* OrdText \* FirstCap } displays "Twenty-first".

\*Ordinal

Displays results as ordinal Arabic numerals. For example, { DATE \@ "d" \* Ordinal } displays "30th".

Note: See the section above relating to the insertion of superscripted ordinals

\*roman

Displays results as Roman numerals. The result has the same case as the word "roman" in the field code. For example, { SEQ CHAPTER \* roman } displays "xi", and { SEQ CHAPTER \* ROMAN } displays "XI".

 

Visit smartadvocate.com/support for other help options including how to access our Support Tracker and Daily Office Hours sessions.