want that when it is typed in this way it validates that it has two digits before the "." and three after the "." . column type text and maximum 6 digits
Solved! Go to Solution.
You want to make sure there are 6 digits and a dot or dash on the third position?
AND(
LEN([_THIS])=6,
IN(
RIGHT(LEFT([_THIS], 3), 1),
LIST(
".",
"-"
)
)
)
Notice that there are always different ways to do this
You want to make sure there are 6 digits and a dot or dash on the third position?
AND(
LEN([_THIS])=6,
IN(
RIGHT(LEFT([_THIS], 3), 1),
LIST(
".",
"-"
)
)
)
Notice that there are always different ways to do this
User | Count |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |