Microsoft KB Archive/22743

“Not a Valid Option” When Entering Decimal Value PSS ID Number: Q22743 Article last modified on 10-17-1990 PSS database name: D_MPlan

3.00 3.01 3.02 3.04 4.00 4.01 4.20

MS-DOS

Summary:

If you try to enter a number with a decimal point in Multiplan, when you press ENTER the message “Not a valid option” may appear.

Check to see what you have specified under Format Units-Currency. If you have specified the comma in the decimal separator field, Multiplan will not accept a period as the decimal point when you are entering a value. The decimal separator is automatically changed to a comma if you select anything other than $ (Dollars) or PD (Pounds) in the Currency: field.

Using a comma as the decimal separator has other side effects that are documented on Page 314 of the “Microsoft Multiplan” manual.

Copyright Microsoft Corporation 1990.