+ Start a Discussion
Manoj.tManoj.t 

Currency Format

Hi,

         could some one help me in currency format like 00,00,00,000.00 format in outputText value?

i tried this but not working....

<apex:outputText value="{0,number,#,##,##0=}00">

thanking you.

AvromAvrom

For me,

 

 

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

 

 

Produces the result

 

12,345.00

 

Is this not what you're expecting?

Manoj.tManoj.t

Thanks

but it doesn't work for 100000.00

it work for till 10000.00

AvromAvrom

Is this data-bound? If so, can you set the type to currency and use an outputField rather than an outputText?

Manoj.tManoj.t

<apex:outputText value="Rs{0,number,##,##,##,##0.00}">
        <apex:param value="{!Quote.GrandTotal}"/>      
       </apex:outputText> 

I am using this  code it works for upto10000

if input is 10000 then output is 10,000.00

but if input is 100000 then output is 100,000.00

is there any solution for this prob.

Thanks in advance

Manoj

AvromAvrom

Sorry; I hadn't understood that you wanted just two characters between every pair of commas but three between the last comma and the dot. There's no simple way to do this with a format mask; VF follows Java's DecimalFormatter in that a constant number of digits between grouping characters is required.

 

I think you may need to do this with Apex code in a controller extension. You'd need a separate String getter that constructs a string by looping through the digits of the number and placing commas in appropriate places.