Thousands separator in excel
Thousands separator in excel
sandrop
Posts: 1Questions: 1Answers: 0
Hello, I have a number in the table on the following format 262,649.4, but when I export it into excel, excel reads the number as string, how is it possible to convert comma to dot after exporting to excel?262,649.4 => 262.649.4
Thank you, regards
This discussion has been closed.
Answers
"262.649.4"
is invalid: you can't have two decimal points in a number and / or your thousands separator may not be the same as your decimal point.
There are so many posts on this in this forum. Did you use @allan's excellent search function?
Take a look at this thread please:
https://datatables.net/forums/discussion/comment/164990/#Comment_164990
In a nutshell: send 262649.4 to Excel and it should work ...