Numeric formatting

[ChuckHixon]

I have a grid with 16 numeric fields. So to make it look less crowded I am using the custom formatting option to show blanks rather then zeros. That works fine.

The problem is I also want the amounts greater than 999 to be formatted with comma separators. The formatNumber function mentions comma's in the documentation but it appears it only formats decimal values with a period.

Am I using the correct syntax for this function or is there another way to show the commas since I cannot use the standard formatting option with java script being present?

formatNumber.png

[sean.lanktree]

This should do it.

return (v === 0) ? '' : Ext.util.Format.number(v,'0,000.00');

[sean.lanktree]

If you do not want decimal places...

return (v === 0) ? '' : Ext.util.Format.number(v,'0,000');

[ChuckHixon]

That works., Thanks!!