Formatting The Appearance of Positive Values

  1. Select the cell you want to modify.

  2. On the Home tab, click Cell, and then click Numeric.

  3. In the Display Positive as list, select the way you want positive balances to appear when printed.
  4. Click OK.

Positive as

Display

x,xxx

5,000

x,xxxDR

5,000DR

Related Topics