+ Start a Discussion
U JayU Jay 

Decimal/ Currency value formatting : Replace dot with comma

I have to replace . With , in from the decimal / currency value within visualforce page using output text without output field.

<apex:outputPanel rendered="{!localeValue != 'Eng'}">

<apex:outputText value="{!countryCurrencySymbol} {!SUBSTITUTE(TEXT(additionalCost.Actual_Price_without_Discount__c),'.',',')}" rendered="{!NOT(ISNULL(additionalCost.Actual_Price_without_Discount__c))}"/>

</apex:outputPanel>




This is my code. Replacement took plae nicely. But the terminating zeroes will not display.

Value in db = 12.30

Value displayed = 12,3

value required = 12,30




Value in db = 12.34000

Value displayed = 12,34

value required = 12,34000




What change i should make?
sandeep sankhlasandeep sankhla
Hi Jyothy,
You can add formatting also in output text, please check with below example adn let me know if that works for you..

<apex:outputText value="{0, number, $###,##0}" ><apex:param value="{!objMemberInformation.SSA_Balance__c}"/></apex:outputText>