Hello Sulada,

By default format is taken from the regional settings object which in JavaScript can be accessed with:

$.ig.regional.defaults

For these settings to take effect for number columns you need to configure igGrid.options.autoFormat option to "dateandnumber". If you're using EN regional settings then the group separator by default is "," which should work for you.

Here is an example:

$(".selector").igGrid({
    autoGenerateColumns: false,
    autoFormat: "dateandnumber",
    columns: [
        { headerText: "Product ID", key: "ProductID", dataType: "number", format: "number" },
        { headerText: "SafetyStockLevel", key: "SafetyStockLevel", dataType: "number", width: "200px" }
    ]            
});

You still have the option to configure the formatting on per column basis by using igGrid.options.columns.format option like this:

$(".selector").igGrid({
    autoGenerateColumns: false,
    columns: [
        { headerText: "SafetyStockLevel", key: "SafetyStockLevel", dataType: "number", width: "200px", format: "###,###,###.##" }
    ]            
});

Hope this helps,
Martin Pavlov
Infragistics, Inc.

Use the columnCssClass property to add a class to the column cells and in the class apply text alignment right.

There is an example:

.align-right {
    text-align:right;
}

$(".selector").igGrid({
    autoGenerateColumns: false,
    columns: [
        { headerText: "SafetyStockLevel", key: "SafetyStockLevel", dataType: "number", 
width: "200px", format: "###,###,###.##", columnCssClass: "align-right"}
    ]            
});

Hope this helps,
Martin Pavlov
Infragistics, Inc.