How to get the currency symbol € at the end of the number
How to get the currency symbol € at the end of the number
Flavien
Posts: 4Questions: 1Answers: 0
Hello,
Thanks for this great tool, we can do a lot with it.
We're struggling with numbers and the currency symbol €.
As you may know, in contrast to dollar symbol, € symbol has to be put at the end of the number, ie : 1 000,00€ not €1 000,00
Could you please tell us how to make this, we did not find the solution in documentation and previous blog post.
Thanks !!
This question has an accepted answers - jump to answer
This discussion has been closed.
Answers
Any frenchy/euro user/expert ready to share some insights on this ?
You need to use the columns.render() option for that column.
This should do it
{ data: "salary", render: $.fn.dataTable.render.number( ',', '.', 0, '', '€' ) }
See this post and the link in it.
http://datatables.net/forums/discussion/23496/add-dollar-sign-and-two-decimal-places-to-an-entire-column
As a quick note, you need to use DataTables 1.10.8 in order to be able to postfix to numbers.
Allan
OK Allan & thank you both for the answer
Is the DataTables 1.10.8 officialy released or soon ?
I've seen it's avalaible from the cdn.
+
OK Allan & thank you both for the answer
Is the DataTables 1.10.8 officialy released or soon ?
I've seen it's avalaible from the cdn.
+
If it is on the CDN then it is released :-). And yes, it is.
Allan