Microsoft KB Archive/77240

= How Money Rounds Numbers =

Article ID: 77240

Article Last Modified on 1/18/2007

-

APPLIES TO


 * Microsoft Money 2004 Deluxe Edition
 * Microsoft Money 2003 Deluxe Edition
 * Microsoft Money 2003 Deluxe and Business Edition
 * Microsoft Money 2003 Standard Edition
 * Microsoft Money 2002 Standard Edition
 * Microsoft Money 2001 Standard Edition
 * Microsoft Money 2000 Standard Edition
 * Microsoft Money 99 Standard Edition
 * Microsoft Money 98 Standard Edition
 * Microsoft Money 97 Standard Edition
 * Microsoft Money 2000 Business & Personal Edition

-



This article was previously published under Q77240



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

Additional query words: round rounding currency numbers money97 money98 money99 money2000 money2001 money2002 money2003

Keywords: kbhowto KB77240

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.