Using Numeric Picture Switches
  • 13 Mar 2024
  • Contributors
  • Dark
    Light
  • PDF

Using Numeric Picture Switches

  • Dark
    Light
  • PDF

Article summary


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.
{ = 1/8 \# 0.00x } displays 0.125.
{ = 3/4 \# .x } displays .8

. (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

  1. 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.


Was this article helpful?