“Number” is one of the patterns that you can select on the Match panel. Use this pattern to make a field match a decimal number that may or may not have decimals, thousand separators, currency symbols, signs, exponents, etc.
Type in the minimum number that the field is allowed to match when limiting values. The minimum only restricts the integer part. It does not restrict the fraction or exponent.
The minimum is ignored in the "none" and "loose" field validation modes, which always allow any integer. In "average" mode, the field will allow any integer part with at least as many digits as the minimum value. In "strict" mode, the regular expression will limit the integer part to the exact minimum value, which may require a complex regular expression.
Type in the maximum number that the field is allowed to match when limiting values. The maximum only restricts the integer part. It does not restrict the fraction or exponent.
The maximum is ignored in the "none" and "loose" field validation modes, which always allow any integer. In "average" mode, the field will allow any integer part with at most as many digits as the maximum value. In "strict" mode, the regular expression will limit the integer part to the exact maximum value, which may require a complex regular expression.
Select the style of the decimal separator that the number should use. This option only has an effect when the maximum number of decimals is not zero.
Enter the minimum number of decimals that the number should have.
Enter the maximum number of decimals that the number is allowed to have.
Select the style of the thousand separators that the number is allowed to use.
Note that with the field validation mode set to "none" or "loose", the regular expression will allow the thousands separator anywhere in the integer part of the number. In "average" and "strict" modes, the regular expression will require the thousands separator to properly split the number in groups of 3 digits.
Choose whether the allowed currency sign(s) and/or code(s) should appear before the number, after the number, or either before or after the number.
Note that if you select "either", the regular expression will allow the number to have two currency signs, one before and one after it, unless you set the field validation mode to "strict".
Choose to allow one of five common currency signs, none of them, or all of them.
Type in a list of currency codes that the field should allow. Delimit the codes with semicolons.
Turn on to allow the field to match only numbers with the integer part between a certain minimum and maximum number.
Turn off to allow any number.
This option has no effect in the "none" and "loose" field validation modes, which always allow any number.
Turn on to allow positive numbers to be preceded with an optional + sign.
Turn off to disallow the + sign.
Turn on to allow negative numbers to be preceded with a - sign.
Turn off to disallow the - sign.
When limiting the integer part with a negative minimum, you must turn on either "allow minus sign" or "allow parentheses" or both.
Turn on to allow negative numbers to be enclosed between ( and ) parentheses.
Turn off to disallow the parentheses.
When limiting the integer part with a negative minimum, you must turn on either "allow minus sign" or "allow parentheses" or both.
Turn on to require positive numbers to use the plus sign.
Turn off to allow positive numbers without any sign.
This option does not have any effect unless allow plus sign is turned on.
Turn on to allow spaces between the sign and the number.
Turn off to require the sign to be immediately adjacent to the number.
This option does not have any effect unless one or more signs are allowed.
Turn on to require the number to use the selected thousand separator.
Turn off to make the thousand separator optional.
This option does not have any effect when the thousand separator is set to "none".
This option has no effect in the "none" and "loose" field validation modes, which do not check if the thousand separators are positioned exactly.
Turn on to allow the field to be preceded by one or more zeros beyond the normally required or allowed number of digits when limiting the values accepted by the field.
This option has no effect in the "none" and "loose" field validation modes, which always allow any integer with any number of digits.
Turn on to require the number to always have an integer part, even when that is zero.
Turn off to make the integer part optional for fractional numbers between -1 and 1.
This option has no effect when the number cannot have decimals, or when the integer part is limited to exclude zero.
Turn on to allow the number to be written in scientific notation with an exponent.
Turn off to disallow the exponent.
Turn on the require the number to have a currency sign or code.
Turn off to make the currency sign or code optional.
This option only has an effect if one or more currencysign(s) and/or code(s) are allowed.