Number format

Hi, i’m using the grid and i have an edn column with “$0,000.00” format, is there any way that i can convert the values of this column in thousands without having to divide by 1000?? For example if i have this value 52100, i want to display 52 or 52,10. In excel this is posible with the format 0, or 0. depending of the regional settings. Help please.



Thanks in advance.

Unfortunately existing “format” functionality doesn’t support such operation.
The only way to implement such format - custom excell, you can create a custom excell and redefine getValue and setValue methods so they will multiple|divide value by 1000. 

…setValue = function(val){
    this.setCValue(val/1000,val);
}

…getValue = function(){
        return parseFloat(this.cell.innerHTML)*1000;
    }