I am thinking of a way to get rid of the $ sign of a currency field in email template. One way to do this is to create a new formula field of number to copy the value which seems a bit clumsy to me. Is there a formula in email template which I can use to get rid of that dollar sign?

  • did you try using TEXT or VALUE functions on the merge field ? – Vamsi Krishna Jan 8 '18 at 1:27
  • 1
    @VamsiKrishna TEXT() seems to work for text based email templates but doesn't seem to work for html based ones... Strange. – Lance Shi Jan 8 '18 at 1:57
  • have you tried VALUE(TEXT(your field here )) - converting to text then back to a raw number? Not sure if it would work - but worth a shot. – Ronnie Jan 8 '18 at 3:50
  • If a VF email template, you have much more control – cropredy Jan 8 '18 at 7:01

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.