function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Timmy AhluwaliaTimmy Ahluwalia 

Currency Format

Hi 
How can i format the currency to french currency format while displaying on VF page.
as $111,112,123.00
Replace to 111 112 123,00 $(Fench Format)
Thanks
Raj VakatiRaj Vakati
You need to use apex:outputText with formate as shwon below 

  
<apex:outputText value="{0, number, ### ### ### ###,00} $">  
      <apex:param value="{!Account.Amount__c}"/>  
 </apex:outputText>

 
Timmy AhluwaliaTimmy Ahluwalia
HI Raj
its displaying as 20,55,37 $
I need gap after three digits.
Thanks
Raj VakatiRaj Vakati
<apex:outputText value="{0, number, ### ### ### ###,000} $">  
      <apex:param value="{!Account.Amount__c}"/>  
 </apex:outputText>

 
Raj VakatiRaj Vakati
<apex:outputText value="{0, number, ### ### ### ### 000} $">  
      <apex:param value="{!Account.Amount__c}"/>  
 </apex:outputText>

 
Timmy AhluwaliaTimmy Ahluwalia
value="{0, number, ### ### ### ###,000} $">     output  20,55,37 $
"{0, number, ### ### ### ### 000} $">                output  205537 $
US $205,536.69    French  205 536,69 $
i need gap after three digits.
Thanks
Alain CabonAlain Cabon
Hi,

It is impossible by this way. The locale settings of the connected user is never used.

You need to use workarounds:

https://salesforce.stackexchange.com/questions/56613/outputtext-number-formating-with-space-a-thousand-separator
https://salesforce.stackexchange.com/questions/21384/format-decimal-in-apexoutputtext-respecting-the-users-locale