Formatting currency

[PietervkParticipant]

Is there a way to format currency in a column as “€12.345,67”?

I have tried with { text: ‘Krediet’, dataField: ‘Credit’, width: 105, cellsformat: ‘c2’ }

This renders “$12,456.67”, even though on my PC, the currency format is specified as shown above.

It is not necessary for my purpose to have c2 to be culture dependend, but I can’t find a way to get the dots and comma’s reversed, even when using ‘f2’.

Thanks

Pieter

[StanislavParticipant]

Hello Pieter,

Here is an old topic with the same question: Link

Best Regards,
Stanislav

jQWidgets Team
http://www.jqwidgets.com/

[PietervkParticipant]

Hi Stanislav, that topic is about the currency symbol, which helps, thanks.
My question is also about the number formatting: i get 12,456.78 but in Dutch culture setting, it should be 12.456,78

How can I get that?

Thanks

Pieter

[StanislavParticipant]

Hello Pieter,

Ah ok, so you can use

localizationobj.decimalseparator = “.”;
localizationobj.thousandsseparator = “,”;

They are both located in the localizestrings in the Grid’s API.

Best Regards,
Stanislav

jQWidgets Team
http://www.jqwidgets.com/

[PietervkParticipant]

Thanks, that works!

[Author]

Posts