Answers

• ThomD Posts: 334Questions: 11Answers: 43

  September 2015 edited September 2015

  This example shows how to use the number rendering function.

  { data: "salary", render: $.fn.dataTable.render.number( ',', '.', 0, '$') }

  https://editor.datatables.net/examples/simple/simple.html

  -fixed some odd copy/paste artifacts
• guoguoguo Posts: 3Questions: 2Answers: 0

  September 2015

  @ThomD

  Thanks, but the solution requires a fixed count of the column. In my tables they are not fixed. Some table has 5 columns and some has 7. Is there kind of something any 'global settings'?
• allan Posts: 63,356Questions: 1Answers: 10,444 Site admin

  September 2015

  You can still use that approach, but use columnDefs to target one or more columns either by column index or by class name. You do need to tell DataTables which columns you want to format though - it won't just apply a global formatter to all numbers.

  Allan