Add validation on numeric column when user fills control using coma

Question

I need to add validation on a numeric column. An error should be when the user fills the control with a decimal number using a comma instead of a dot.

I have a formula which looks like this:

=AND(IF(ISERROR(FIND(",", MyNumericColumn)),TRUE))

And it doesn't work. But if I change the character to a dot".", it will find it correctly. Any ideas how to add validation on comma?

Answer 1

As per my test, I am not able to find the comma (,) in number column using SharePoint formulas. So, it is difficult to add such validations.

Workaround:

Use single line of text field instead of number column & use below column validation:

=ISNumber([MyColumnName] + 0)