Skip to main content
Salesforce Admin ADMA 님이 #Data Management에 질문했습니다
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개
  1. 2014년 6월 3일 오전 5: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.

0/9000