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
 
-------------------------------------------------------------------
The information in this article applies to:
 
 - Microsoft Money versions 1.x, 2.x, and 3.x
 - Microsoft Money version 4.0 and 4.0a for Windows 95
-------------------------------------------------------------------
 
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.