Validate a Single line of text column type of list in sharepoint 2010 to accept only numbers?

sharepoint-2010 sharepoint-list
SharePointKID picture SharePointKID · May 12, 2011 · Viewed 8.2k times · Source

How to validate a Single line of text column type of list in sharepoint 2010 to enter accept only numbers?

Please don't tell me to use calculated column , I tried it and it didn't work for me as i want.

Please advice, thanks in advance.

Answer

Rob Windsor picture Rob Windsor · May 14, 2011

This should work:

=ISNUMBER([MyColumn]+0)

Related questions

Change SharePoint Library URL

How do you change the URI of a SharePoint library? Based on Google searching, most people say that changing the name of a library in Designer (via right click->rename) will result in the URI change, but it is …

Read More
Update multiple SharePoint list Items

I have an InfoPath form that, when submitted to a SharePoint Form Library, also adds a single item to a Task List. Each item in the Task List contains a People field that may contain multiple names. I have code …

Read More
How to show only the year field in Sharepoint date and time(Today)

I want a field in which only the year of the present date(Today) is shown.I had tried many methods but couldn't find any solutions.Can anyone help me with the problem. I am new to sharepoint, so please …

Read More