Money Error Message: '###.##' Is an Invalid Amount Because It Is Either Non-Numeric or Too Large for This Field (270850)



The information in this article applies to:

  • Microsoft Money 98
  • Microsoft Money 97
  • Microsoft Money 2001
  • Microsoft Money 2000
  • Microsoft Money 99
  • Microsoft Money 2000 Business and Personal

This article was previously published under Q270850

SYMPTOMS

When you type a value in the Amount box in a transaction in Microsoft Money, you may receive one of the following error messages:
'###.##' is an invalid amount because it is either non-numeric or too large for this field. Please try a number that uses no more than 14 digits (including those after the decimal point, even if they're zero).
'###.##' is an invalid amount because it is either non-numeric or too large for this field. Please try a number that uses no more than 9 digits (including those after the decimal point, even if they're zero).

CAUSE

This behavior may occur if the decimal symbol has been formatted to be a comma (,) instead of a period (.). You select this formatting in the Regional Settings for Windows.

RESOLUTION

Microsoft Windows 98, Microsoft Windows NT 4, and Microsoft Windows 2000

To work around this issue, change the digit grouping symbol to the period instead of the comma. To change the digit grouping symbol:
  1. On the Windows taskbar, click Start.
  2. Point to Settings, and then click Control Panel.
  3. Click Regional Settings (Regional Options in Windows 2000).
  4. Click the Number tab.
  5. In the Digit grouping symbol box, type the symbol that you want or replace the symbol with a blank space, and then click OK.

Windows XP

  1. On the Windows taskbar, click Start.
  2. Click Control Panel.
  3. Click Date, Time, Language, and Regional Options.
  4. Click Change the format of numbers, dates, and times.
  5. On the Regional Options tab, click English (United States).
  6. Click OK.

Modification Type:MajorLast Reviewed:1/5/2005
Keywords:kbenv kberrmsg kbprb KB270850