script to automatically add commas to pre-existing values in number field
Our accountant is having difficulty reading the amount in our value field (number field). Is there a way to automate this to pre-existing values?
Not every record would require this (example 300 or $300) but some would (example 30000 or $30,000).
The dollar symbol is not needed, just the comma.