What is the Best Practice to display number field without a thousands separator (comma or period, depending on locale)?
I have rejected the following ideas:
- Text field, because I have to write Validation Rule for number. Performance will be affected.
- Phone field, because in case of editing in UI, Salesforce changes 10 digit numbers to match US formatting.
I am looking for best practice, because no clean solution is available. All are dirty solutions.
- There is no decimal
- I won't use the field on VF pages; I'll use the field in reports, and hence don't want the comma in my report tab - if the comma isn't there on the report tab, it won't reflect in the downloaded XLS too