Check if a value is a number

[kvocat]

Dear all,

I have a text value in which I put what the scanner reads... However, even if the value coded with the barcode is a 8 digit, sometimes I have alphanumeric values inside my text... How can I check the value is really a numeric ?

Thanks for your help.

Kim

[lynchk21]

Seems like you could use EXTRACTNUMBERS(text-to-extract-from) and then if needed you could compare with the original to see if there were non-numeric values in the text-to-extract-from

[mikeas]

Hi Kim,

You can also use the NUMBER function to convert text to a number. This will fail if the text has any non-numeric characters, so you can then check if the result was not blank (meaning it succeeded):

ISNOTBLANK(NUMBER([Scanned Text Value]))