[Solved] How format number in Spanish Localization?

[Daniel]

Hi.

A column in my grid is a number and I would like to format with millar separation and non-decimals.

Example: 123456  ---> 123.456
                12345678 --> 12.345.678
                10 -> 10
                100 -> 100
                1000 -> 1.000

Like Excel formating I use:

columns.Bound(o => o.Valor).Title(

"Valor").Format("{0: #.##0}");

 

But the grid show for 1200  (an example) --> 1200,000 and I need 1.200

What is wrong?

Thanks.

PD: In the aspx page, I use Culture="es-ES". I trie the grid localization .Localizable("es-ES") but didn't work.

[Georgi Krustev]

Hello Daniel,

If grid uses Ajax binding, you need to turn on globalization on the client using Globalization(bool)
method of the ScriptRegistrar:

<% Html.Telerik().ScriptRegistrar().Globalization(true) %>

The Globalization(...) method will serialize the required Culture properties to the client.

Regards,
Georgi Krustev
the Telerik team

[Daniel]

Hi Georgi.

I tried your suggestions, but the grid still show the same format number.

For 1200, it show 120,000    ; and I need 1.200

My current format is: Format("{0: #.##0}");

I attach a image.

Thanks.

[Georgi Krustev]

Hello Daniel,

You can try with something like that :

{0:#,##0}

For more information I suggest you check this help topic.

Regards,
Georgi Krustev
the Telerik team