How Money Rounds Numbers (77240)

SUMMARY

The number of decimal places stored internally in Money is based on the decimal setting in the Control Panel at the time the file was created. Once the file is created, even if the Control Panel is changed to reflect a different decimal setting, Money rounds internally to that initial setting.

The formatting on the screen is based on the current Control Panel setting.

MORE INFORMATION

Even though Money accepts a value with 17 digits to the right of the decimal as input, it does not track amounts of 1/10th of a cent or less. Instead, Money rounds up or down based on the following:

   Entered                  Rounded
   Value                    Value

   --------------------------------

   $0.0000 to $0.0049        $0.00
   $0.0050 to $0.0099        $0.01

Rounding Examples

9,999,999.9949 rounds to 9,999,999.99. Whereas 9,999,999.9950 produces the following error message in Money 97:
'9999999.9950' is an invalid amount. Money does not recognize values that are too large or non-numeric values for this field. Please type a number that uses no more than nine digits, (including those after the decimal, even if they're zero). Please type a number that uses no more than nine digits (including those after the decimal, even though they're zero).
Whereas 999,999,999,999.9950 produces the following error message in Money 98 or later:
'999,999,999,999.9950' is an invalid amount because it is either non-numeric or too large for this field. Please type a number that uses no more than 14 digits (including those after the decimal point, even if they're zero).
.00000000000000001 rounds to $0.00