Unbevielable but the truth: Display a number without thousand operator and without decimal points is possible – and i did not code anything for it.
I tried to create a column which only shows an integer with six characters. This integer is a identical number for a project, for example. I checked several options till i found this smart easy no-coding solution:
- Create a column
- Column is mandatory and is primary key
- set maximum character to 6
- Insert into column validation the following formula: =ISNUMBER([Column]+0)
- User Dialog: Please type in a number!
Now you have a column, where the user can only insert numbers with a maximum of 6 characters and it will always display the number without thousand separator. I found this solution here.
If you want to go a step further and say, well – i want that the number is always six characters and only numbers are awaited, then use this formula:
It is really nice, because it also displays when your number starting with zero. The last function also validates, that you have to insert at least 6 characters.
..:: I LIKE SHAREPOINT ::..
He is Consultant for SharePoint Solutions for collaboration, communication and business processes. He provides his customers applications based on standard features as well as development or combining the power of several microsoft tools like Dynamics CRM. In his free time he tries to collect tipps and worthy experience in this blog.