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 ::..The article or information provided here represents completely my own personal view & thought. It is recommended to test the content or scripts of the site in the lab, before making use in the production environment & use it completely at your own risk. The articles, scripts, suggestions or tricks published on the site are provided AS-IS with no warranties or guarantees and confers no rights.
Karsten Pohnke – has written 185 posts on this site.
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.