Hi Razvan,

If you try changing your column type from number to currency in SharePoint and then select the format of the currency for your particular locale then SharePoint itself would validate how the format of the currency should be.

Regards,

Shrini

I don't believe you are supposed to be entering commas in a number defined field. If I'm not mistaken the commas will automatically appear for you. Does this have to be defined as a Number field. Why not keep it a text field and then use Reg Edit or Replace()?

Hi Shrini, thanks for that idea, I will give this a try although my requirement is that no commas or dots or whatever should be accepted as an input value. Basically I want integers  Is there no other way to do this but to use currency? It has 4 digits accuracy after the decimal point, I don't really need that kind of precision.

Hi burkslm, actually you can - I am actually experiencing this behavior and it is quite acceptable when you need the decimal precision. However I do not need these, basically I need integers. Validation with regex does not "see" the comma  0-9]+ even if it is there - quite weird behavior.

Replace is a good idea, however I consider this to be basic functionality and it should be doable without JavaScript. If nothing else works I suppose I will have to give that a try.

not sure how did you test, but regular expression definitely rules out dot and comma characters