Macro Sheets Only
Equivalent to pressing the Constrain Numeric button in the Formula category of the Customize dialog box, which appears when you choose the Toolbars command from the View menu and then choose the customize button. Constrains handwriting recognition to numbers and punctuation only. Use this function in a macro to improve the accuracy of handwriting recognition when the user is entering a series of numbers or formulas.
Note This function is only available if you are using Microsoft Windows for Pen Computing.
Syntax
CONSTRAIN.NUMERIC(numeric_only)
Numeric_only is a logical value that turns the numeric constraint on or off. If numeric_only is TRUE, only numbers and digits are recognized; if FALSE, all characters are recognized as usual. if numeric_only is omitted, the numeric constraint is toggled.
Remarks
When the numeric constraint is on, Microsoft Excel recognizes only the following symbols:
0 1 2 3 4 5 6 7 8 9 $ # @ % ( ) - + = { } : < > , ? | .
Tip Use GET.WORKSPACE(45) to make sure you're running Microsoft Windows for Pen Computing.
Related Functions
List of Command-Equivalent Functions