Skip to main content
Topics#Data ManagementFrage von Salesforce Admin ADMA
Salesforce Admin ADMA fragte in #Data Management
3. Juni 2014, 01:25

data type number without Comma

I am using Data Type Number: for one of the fields, but it results in comma. How can I keep this as a number field without comma.
2 Antworten
  1. Chidambar Reddy (FormulaQ Solutions Private Limited)
    3. Juni 2014, 05:49
    Hi Bindu,

     

    This cannot be done in standard way, It is still an Idea

     

    https://success.salesforce.com/ideaView?id=08730000000BrGKAA0

     

    There is a workaround for this 

    Create a new custom field, where type is "formula" and the formula return type is "text".
    In the formula, use the TEXT() function, and pass the existing number field value into this formula. 
    For example, if your number field is MyNumber_c then your formula would be: TEXT( MyNumber_c )
    Your users will enter values into the existing number field, but you can use the formula field (which doesn't display thousands separators) in reports, list views etc.
Antwort schreiben...
0/9000