- Print
- DarkLight
- PDF
Using Numeric Picture Switches
Picture Item | Function |
---|---|
0 (zero) | Specifies the numeric places to display in the result. If the result does not include a digit in that place, Word displays a 0 (zero). For example, { = 4 + 5 \# 00.00 } displays 09.00. |
# | Specifies the requisite numeric places to display in the result. If the result does not include a digit in that place, Word displays a space. For example, { = 9 + 6 \# $### } displays $15. |
x | Drops digits to the left of the "x" placeholder. If the placeholder is to the right of the decimal point, Word rounds the result to that place. For example: { = 111053 + 111439 \# x## } displays 492. |
. (decimal point) | Determines the decimal point position. For example, { = SUM(ABOVE) \# $###.00 } displays $495.47. |
, (digit grouping symbol) | Separates a series of three digits. For example, { = NetProfit \# $#,###,### } displays $2,456,800. |
- (minus sign) | Adds a minus sign to a negative result, or adds a space if the result is positive or zero. For example, { = 10 - 90 \# -## } displays -80. |
+ (plus sign) | Adds a plus sign to a positive result, a minus sign to a negative result, or a space if the result is zero. For example, { = 100 - 90 \# +## } displays +10, and { = 90 - 100 \# +## } displays -10. |
%, $, *, &, etc. | Includes the specified character in the result. For example, { = netprofit \# "##%" } displays 33%. |
"positive; negative" | Specifies different number formats for positive and negative results. For example, if the bookmark RealGainLoss is a positive value, the field { RealGainLoss \# "$#,##0.00;-$#,##0.00" } displays the value with regular formatting. A negative value is displayed with bold formatting and a minus sign. |
"positive; negative; zero" | Specifies different number formats for a positive result, a negative result, and a zero result. For example, depending on the value of the RealGainLoss bookmark, { RealGainLoss \# "$#,##0.00;($#,##0.00);$0" } displays positive, values with regular formatting, negative values surrounded by parenthesis, and zero values as bold. |
'text' | Adds text to the result. Enclose the text in single quotation marks. For example, { = { Price } *8.1% \# "$##0.00 'is sales tax' " } displays $347.44 is sales tax. |
Example: Changing a Negative Sign to a Parenthesis
- Select the numeric field that you want to change and do one of the following:ick the View Field Codes button on the toolbar.
- Select View > Field Codes.
- Press Alt+F9 on your keyboard.
- Right-click on the field and select Toggle Field Codes.
- The code for the numeric field will appear in your document.
In the date field, select the text in between the quotes and change it to
MMM d, yyyy.
Right-click on the field and select Update Field.Right-click on the field again and select Toggle Field Codes. The date will now appear in your document in written out format.