Microsoft KB Archive/138112

Money: Incorrect Decimal Places or Amounts Rounded Incorrectly

PSS ID Number: Q138112 Article last modified on 09-12-1997

1.x 2.x 3.00 3.00a 4.00 4.00a

WINDOWS

=
========================================================= 1.x 2.x 3.00 3.00a 4.00 4.00a WINDOWS kbsetup kbusage kbui kbenv kbprb

= SYMPTOMS =

Some numbers containing decimals are incorrect. You experience one or both of the following problems:


 * Your account register shows transactions with incorrect decimal places or incorrect rounding. This may not happen in all Money files. For example:
 * You enter 1.49; you see 1.00 on the screen
 * You enter 1.51; you see 2.00 on the screen
 * The number of digits seen to the right of the decimal point are incorrect. This happens in all Money files. For example:
 * You enter 1.49; you see on the screen 1 or 1.5
 * You enter 1.51; you see on the screen 2 or 1.5

= RESOLUTION =

Verify that the Decimal settings in the Windows Control Panel are correct. Exit and restart Money.

If the rounding problem still exists, you need to create a new Money file, and then import your accounts into the new file. After importing your accounts into the new Money file, you need to manually reenter any incorrectly rounded amounts.

NOTE: Importing your accounts into a new Money file does not repair incorrectly rounded amounts in existing transactions. However, any newly entered or imported transactions will be correctly rounded.

= MORE INFORMATION =

Verifying and Checking Control Panel Settings
Changing the Control Panel decimal setting changes the decimal formatting seen on screen. Use the instructions below to change the decimal settings in your version of Windows:

NOTE: The following examples use settings for the United States.

Windows 95

 * 1) Exit Money.
 * 2) Click the Start button, point to Settings, and then click Control Panel.
 * 3) Double-click Regional Settings.
 * 4) Click the Number tab.
 * 5) Change the Decimal Symbol to a period (.).
 * 6) Change No. Of Digits After Decimal to 2.
 * 7) Click OK.
 * 8) Start Money and examine the decimal formatting.

If the number of digits to the right of the decimal point is correct, but the rounding is still incorrect, you must import your accounts into a new Money file.

Windows 3.x

 * 1) Exit Money.
 * 2) Double-click the Control Panel icon, usually found in the Main group of Program Manager.
 * 3) Double-click International.
 * 4) In the Number Format area, click the Change button.
 * 5) Change the Decimal Separator to a period.
 * 6) Change Decimal Digits to 2.
 * 7) Click OK, and then OK again to close International.
 * 8) Close the Control Panel.
 * 9) Start Money and examine the decimal formatting.

If the number of digits to the right of the decimal point is correct, but the rounding is still incorrect, you must import your accounts into a new Money file.

Fixing Incorrect Rounding
The number of decimal places stored internally in each Money file is based on the decimal setting in the Windows Control Panel when you created the file. To fix incorrect rounding, you need to create a new Money file. Your existing accounts can then be imported into this new Money file.

For information on how to export the accounts from your current file and import them into a new file, please see the following article in the Microsoft Knowledge Base:

ARTICLE-ID: Q141268 TITLE : Handling Error Messages or Problems Related to Money Files

After you import your accounts into the new Money file, you need to manually reenter any incorrectly rounded amounts.

For additional information on how Money rounds numbers, please see the following article in the Microsoft Knowledge Base:

ARTICLE-ID: Q77240 TITLE : How Money Rounds-Off Numbers

KBCategory: kbsetup kbusage kbui kbenv kbprb KBSubcategory:

Additional reference words: w_money 4.00 4.00a 1.x 2.x 3.00 3.00a 4.00 4.00a roundup truncation round Babyface

=
========================================================= Version : 1.x 2.x 3.00 3.00a 4.00 4.00a Platform : WINDOWS ============================================================================= Copyright Microsoft Corporation 1997.