Use point as a thousand separator and comma as decimal separator

Question

The default culture project is this:

public static void setCulture()

{

System.Globalization.CultureInfo ci = new System.Globalization.CultureInfo("es-CO");

ci.NumberFormat.CurrencySymbol = "$";

ci.NumberFormat.CurrencyDecimalSeparator = ",";

ci.NumberFormat.CurrencyGroupSeparator = ".";

ci.NumberFormat.CurrencyNegativePattern = 1;

ci.NumberFormat.CurrencyPositivePattern = 0;

ci.NumberFormat.NumberDecimalSeparator = ",";

ci.NumberFormat.NumberGroupSeparator = ".";

ci.NumberFormat.NumberNegativePattern = 1;

System.Threading.Thread.CurrentThread.CurrentCulture = ci;

System.Threading.Thread.CurrentThread.CurrentUICulture = ci;

}

How can I use it in the next grid?

Or how can I set the point as thousand separator and comma as decimal separator.

Pon Selva Jeganathan · Accepted Answer

Hi Jose,

Thanks for contacting syncfusion forum.

Query: Use point as a thousand separator and comma as decimal separator

To achieve this requirement, we suggest that you to set the Locale property of the grid as “es-CO”. In locale API of the “es-CO” is point as a thousand separator and comma as decimal separator for the numbers.

Please refer to the below code snippet,

Default.aspx

<ej:Grid ID="EmpGrid" runat="server" ClientIDMode="Static" AllowPaging="True" Locale="es-CO">

…

<ej:Column Field="EmployeeID"/>

<ej:Column Field="Freight" Format= "{0:n}"/>

</Columns>

Site.Master:

…..

<head>

……

</head>

Note: To get the particular culture we need to refer the “ej.culture.es-CO.min.js” script file in the sample.

Script Location: C:\Program Files (x86)\Syncfusion\Essential Studio\xx.xx.xx.xx\JavaScript\assets\scripts\i18n

xx.xx.xx.xx àMention your project version

Please refer to the below screenshot:

Please refer to the below sample,

https://www.syncfusion.com/downloads/support/forum/162680/ze/Sample-2039545947

Please refer to the below documentation,

https://help.syncfusion.com/aspnet/grid/localization

https://help.syncfusion.com/api/js/ejgrid#members:locale

Kindly get back to us for further assistance.

Regards,

Pon selva