Categories | Question details Back To List | ||
comma separated format for negative numbers 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? Answer posted by Support on Jul 29, 2008 05:40 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. |