function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
mahimahi 

comma in number field

when i fill 10000 in any field that is of number(18,0) type, comma appears like 10,000.
how it can be removed? is there any setting within salesforce?
 
thanks,
mahi
RickyGRickyG
mahi -

Does the value in the field have to support arithmetic operations?  If not, just define it as a string.

Hope this helps.
mahimahi

-Rick

actually this field is used for capturing PIN code that can be numeral only.

if data type is changed to string , user can put characters with numbers.

isn't there any other method to control that comma field?

mahi
RudsterRudster
HI mahi,
 
Have you found a way to remove the comma from a number field? I need the number to be displayed as entered.
 
Thanks,
 
Rudster
msilbermsilber
If you are just storing a PIN that needs to be numeric, you should use a text fields with an "ISNUMBER" validation rule to ensure it's always a number. Number fields should only be used if you need to perform math. You can't remove the comma in the actual field -- that's default behavior for a number field.

This is from the Salesforce online help (search for ISNUMBER)

ISNUMBER

Description: Determines if a text value is a number and returns TRUE if it is. Otherwise, it returns FALSE.
Use: ISNUMBER(text) and replace text with the merge field name for the text field.
Validation Rule Example: 
OR(LEN(Bank_Account_Number__c) <> 10, NOT(ISNUMBER(Bank_Account_Number__c)))

This validation rule ensures a custom text field called Bank Account Number is a number of 10 digits and is not blank.

Tips:
  • This function returns FALSE for blank values.
  • The ISNUMBER function is not aware of your locale. For example, ISNUMBER("123,12") and ISNUMBER("1 000") return FALSE even if the user's locale is "French."
  • Chinese, Japanese, Korean, and special characters including a space return FALSE.
  • The ISNUMBER function returns TRUE for scientific formatting such as "2E2" or "123.123."
  • This function is available everywhere formulas exist except formula fields and default values.


Hope that helps.

Mark