Help CenterUnits & fieldsLook it up
Number field: quantities, counts, limits and formatting
A number you can add up, sort and compare, with a minimum and a maximum, and the separator format that suits you.
How it works
The format is for display only. The stored and exported value is always the same, so changing it is safe on a field that has data.
When sorting, an empty field counts as the smallest value.
It works in formulas, rollups and catalog matching.
For amounts of money, use Currency: it keeps the currency code and the rounding.
At a glance
Setting
What it does
Minimum value and Maximum value
Reject anything outside the range
Number format
1,234.56 or 1.234,56, for display onlyPrevents duplicates, and
1.0 equals 1.00If something goes wrong
What you see
Why
What to do
“Must be a valid number”
Letters or symbols.
Type digits only.
“Must be at least 0”
Outside the limit.
Correct the value.
Good to know
The minimum can’t be more than the maximum.
It doesn’t accept notations such as
0x1F.Did this guide solve it?
If not, we’ll ask what was missing.