comma separated format for negative numbers

Discontinued products Uncategorized discussions
#1

Hi,





I want to display negative values in comma separated format.(-20,000 for negative 20 thousands)

If I am using cell type “ron”, it gives me an “NaN”.

If using “ro”, i cannot apply the number format.

Any suggestions, to resolve this?

#2

Actually
    mygrid.setColTypes(“ron,ed”);
    mygrid.setNumberFormat(“0,000”,0);
must work for any types of incoming value, including negative numbers.
Working sample sent by email.