Say that we have a Number field called Quote. In the email template, we want to force it to have two decimal numbers.
For example, if it is 4, we want to display 4.00. However, it is an html email template not a Visualforce one so I can't use controller.
And tried to use a formula field to convert it into text via:
text( floor( My_Number__c ) ) + "." + right( text( ( 1 + My_Number__c - floor( My_Number__c ) ) * 100 ), 2 )
However, since Quote__c itself is a formula field this new formula exceeds character limit by Salesforce.
Is there any way I can walk around this issue?