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.