Geek asks and answers

Confirm single row of text column of list list in sharepoint 2010 to accept only numbers?

How to check a single row like list column text type in sharepoint 2010 to enter only a number?

Please do not tell me to use the calculated column, I tried it and it did not work for me as I want.

I ask for advice, thanks in advance.

+3
source share
3 answers

This should work:

=ISNUMBER([MyColumn]+0)
+4
source

I looked at the available functions and I don't see what will check if the text value is a number.

By the way, is there a reason why you are not using the Number field instead of a single line of text?

0
source

, , ( @Rob_Windsor; ):

=AND(
  ISNUMBER(Number+0),
  ISERR(FIND(".",Number)),
  ISERR(FIND(",",Number)),
  ISERR(FIND("$",Number)),
  ISERR(FIND("+",Number)),
  ISERR(FIND("-",Number)),
  ISERR(FIND(" ",Number))
)
0
source

More articles:


All Articles