How to check if values in a cell are numeric or contains only numbers using formula tool

[Vaib]

Hello,

How to check if values in a cell are numeric or contains only numbers using formula tool?

[Luke_C]

@Vaib 

There is a 'isnumber' function you could use:

[Emil_Kos]

Hi @Luke_C,

I wasn't aware that there is a formula like this.

Thank you for sharing. 

[Vaib]

The isnumber function doesnot seem to be working for me. I have date in the cell that I am looking at in the following format 20200331 (yyyymmdd). I just need to check if the value 20200331 is numeric or not.

[Luke_C]

@Vaib 

Can you share the workflow or some sample data? I don't seem to be able to reproduce the behavior you describe.

[Vaib]

So these are dates parsed in from from a csv file and they show up in the text format. Below are few examples of the dates that I am looking at:

20220228

20200331

20270220

20161001

[Vaib]

The format of data is V_String

[Luke_C · Accepted solution]

@Vaib 

Ah, if they're coming in as text fields you could try the 'IsInteger' function. That would check if it would be able to be converted to a number. See attached example.

[Vaib]

This is really helpful. Thank you for guiding me through this!

[amjadmanasra]

Hello everyone, 

I want to highlight IsNumber check the field data type, not the value itself 

to check if the value is a number use RegEx instead something like this :

REGEX_Match([F], "^-?\d+(\.\d+)?$")