| Item |
Guideline |
Example |
| Value separator (delimiter) |
Commas: n, n+1, n+5 |
5,6,7 5.5,6.25 |
| Continuous range of values that includes the specified values |
Brackets: [n, n+5] |
[3,10] = value between 3 and 10, including 3 and 10 |
| Continuous range of values that does not include the specified values |
Parentheses: (n, n+5) |
(3,10) = value between 3 and 10, not including 3 and 10 |
| Less than or equal to (open-ended range) |
Value preceded by comma, enclosed in brackets: [,n] |
[,5] = value less than or equal to 5 |
| Greater than or equal to (open-ended range) |
Value followed by comma, enclosed in brackets: [n,] |
[5,] = value greater than or equal to 5 |
| Greater than |
Value preceded by comma, enclosed in parentheses: (,n) |
(,5) = value greater than 5 |
| Less than |
Value followed by comma, enclosed in parentheses: (n,) |
(5,) = value less than 5 |
| Maximum characters per cell |
256 |
|
| Unit of measurement syntax |
Metric or architectural |
15'1/4" = imperial 15.25 = metric |
| Invalid formats |
If you enter a value in an invalid format, the value will be reset to the last value when you move to another cell in the table. |
|
