Divide By

If you want to divide this column's amount, select one of these options:

  • 1
  • 10
  • 100
  • 1000
  • 10000
  • 100000
  • 1000000

For example, if you want a number to be expressed in thousands, select 1000 in this field.

As another example, you might want to adjust the format to remove the decimal places. In this case, change this format:

 >>>>,>>>,>>9.99

to this format: 

 >>>>,>>>9

in that case, the output would change from this:

 12,345,678.90

To this:

 12,346

Note:  Do not confuse this field with a rounding factor (in the above example, the number would display as 12,346, not as 12,346,000).