How to format numbers with thousand separators?

About formatting numbers with thousand separators, you can achieve this in Table Editor by using the following JavaScript function in the Renderer field

$.fn.dataTable.render.number( thousands_sep, decimal_sep, decimal_places, prefix, suffix )

Here’s what each parameter does:

• thousands_sep: Thousand separator (, for standard formatting)
• decimal_sep: Decimal separator (. for standard formatting)
• decimal_places: Number of decimal places (0 for no decimal places)
• prefix: String before the number ('' for no prefix)
• suffix: String after the number (' $' to add $ after the number)

$.fn.dataTable.render.number(',', '.', 0, '', ' $')

Displayed Output: 1,200,000 $