May I format display numberr to #,###.## ?

aloz

Hi all,

May I format display number to #,###.##, and Percentages to ##.##%, and will not affect the sort results??
(Maybe can align "Right"?)

allan

You can use fnRender ( http://datatables.net/usage/columns#fnRender ) to format the numbers as you wish, and set bUseRendered ( http://datatables.net/usage/columns#bUseRendered ) to false so that sorting and filtering is done on the original data, not the rendered data.

Allan