Display Numeric Fields Without Commas Using Validation Rules
When wanting to display a number field without a comma, I’ve generally made a number field then a formula text field to display the value as text:
TEXT (UN_or_NA_Number__c)
But that makes it ugly when you’re setting up the view and edit layouts.
Not any more! I hadn’t considered this before, but why not just make a text field to begin with and use a validation rule to make sure the value is numeric? Use this code to validate your field:
NOT(ISNUMBER( UN_or_NA_Number__c ))
This is so much nicer and easier to use than having to create duplicate display fields and managing the layouts.