How to Merge Numeric or Currency Fields as Text
You can use Microsoft Word fields to convert data from SmartAdvocate merge codes.
Insert field from the Word toolbar.
Press Alt-F9 if the field is not visible (you can press it again to hide field codes and show values).
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.
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.