You need to sign in to do that
Don't have an account?
PamSalesforce
currency formatting
Hi,
I have a field defined as currency(6,2)
and i want to display it in visualforce page as 123.333,90 €
i am currently using <apex:outputText value="{0,number,###,###.00} €/ anno">
but this displays the currency as 123,333.90 €
I'm pretty sure that <apexutputText value="{0,number,###.###,00} €"> shows 123.333,90 €(this doesn't work, sorry), but if you are talking about automatic currency formatting with the locale setting, I doubt it works.I ended up with formatting by myself with using the SFDC formatting for the integer part, and figuring out the floating point character with
double d = 1.1;
string floatingPointChar = d.format().replaceAll('1','');
and adding floating part by myself. I did it for Canadian-French and US users.
That's one of stupid things I did and I had to do.
ThomasTT
All Answers
I'm pretty sure that <apexutputText value="{0,number,###.###,00} €"> shows 123.333,90 €(this doesn't work, sorry), but if you are talking about automatic currency formatting with the locale setting, I doubt it works.I ended up with formatting by myself with using the SFDC formatting for the integer part, and figuring out the floating point character with
double d = 1.1;
string floatingPointChar = d.format().replaceAll('1','');
and adding floating part by myself. I did it for Canadian-French and US users.
That's one of stupid things I did and I had to do.
ThomasTT
Hi,
The code works fine for both American and European format.
My system had English(US) settings so it showed american format.
I had asked my client to check if it showed proper European format and it did.
Thanks all.