LEN([BARCODE])=LEN(TEXT(NUMBER([Barcode])))
Can I get a second opinion on if the above valid if formula means that my [Barcode] column canโt contain a non number character? It seems to but I havenโt done thorough testing.
Solved! Go to Solution.
TEXT() will render the Number value for display, which will include thousands separators if the number has enough digits. Does the original value have thousands separators? Perhaps use CONCATENATE() instead to avoid display formatting.
Converting a textual numeric value to a numeric value then back to a textual value will strip leading zeros, which could change the length of the converted value. Youโll need to handle that.
([BARCODE] = RIGHT(("0000000000" & NUMBER([BARCODE])), LEN([BARCODE])))
TEXT() will render the Number value for display, which will include thousands separators if the number has enough digits. Does the original value have thousands separators? Perhaps use CONCATENATE() instead to avoid display formatting.
Converting a textual numeric value to a numeric value then back to a textual value will strip leading zeros, which could change the length of the converted value. Youโll need to handle that.
([BARCODE] = RIGHT(("0000000000" & NUMBER([BARCODE])), LEN([BARCODE])))
You are extra right too since the barcode can start with 0s!
User | Count |
---|---|
35 | |
35 | |
28 | |
23 | |
18 |