Converting the Numbers in the stats to the Nordic Number Format
Comments
-
Hi Mahulima,
I have found there is a community function called Comma Separate Number that can do almost just that.
Comma Separate Number - 'Inserts a comma separator every three digits so 99999.99 becomes 99,999.99'
Then 'Replace' the commas with spaces.
If the function above is not available/ showing up, you can recreate it using 'Regular expression replace' with the following expressions:
Search value: (?:^|\G)(\d{1,3})(?=(\d{3})+(?:\.\d+)?$)
Replacement value: $1,
Hope that helps
3
Categories
- All categories
- 17 Get started
- 467 Get involved
- 8 Support
- 269 Resources
- 3 Events
- Upcoming events
- 3 Event recaps
- 18 Ideas and roadmap
- 218 Community categories