I created a number field with options, Required, Unique and External Id checked, and want to use formula to convert Employee Number to text to prevent commas from displaying in the field. I tried to use VALUE(Employee_Number___c) or TEXT(Employee_Number__c) but system will not allow it. Puzzled.

  • I created an external id number field and then a second field as a formula using TEXT(external_id__c) without an issue, what type of error are you getting. – Jenny B Nov 3 '14 at 22:09
  • 1
    You can't use the default formula to cause this, if you're trying to make the number field not use commas. Instead, make it a text field and a validation rule to prohibit anything outside 0-9. – sfdcfox Nov 3 '14 at 22:21

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.