+ Start a Discussion
Rick MacGuiganRick MacGuigan 

Numbers without commas and anything else.

What are people doing for numeric input fields where "no comma" is required ? I've seen the use of text fields but find this a bit odd especially if you need to use a number that is displayed as a integer without commas. I need this for non-arithemetic computations .

Appreciate best practices on this. Thanks.
Best Answer chosen by Rick MacGuigan
PratikPratik (Salesforce Developers) 
Hi Rick,

Currently it's not possible.
There is an Idea: 
https://success.salesforce.com/ideaView?id=08730000000BrGKAA0

Workaround:
create a formula field with Text as return type.
Formula: Text( numberfield__c )

Thanks,
Pratik

All Answers

PratikPratik (Salesforce Developers) 
Hi Rick,

Currently it's not possible.
There is an Idea: 
https://success.salesforce.com/ideaView?id=08730000000BrGKAA0

Workaround:
create a formula field with Text as return type.
Formula: Text( numberfield__c )

Thanks,
Pratik
This was selected as the best answer
Rick MacGuiganRick MacGuigan
Thanks. I was hoping this was not the case. I'll need to use a text field as my users need to enter data without seeing the commas.
PratikPratik (Salesforce Developers) 
Hi Rick,

Yes for now with text field, ideas are there to have this feature and salesforce may consider this in future releases.

Thanks,
Pratik
Mano sfdcMano sfdc
Hi Rick,

Use below validation Rule. It we resolve your issue.

NOT(REGEX(Field__c ,  '^[0-9]*$'))

Thanks,
Manohar
Note: If this answers you question, please mark it as "Best Answer" so it will help other community members too.