Hello Dojo,
I have a scheduler task to send out an email of a Dashboard report with the CSV option enabled. There are values in the table that have values greater than 1000. Those values, when viewed in Excel, are being interpreted as decimal values, so 12,345 is showing up as 12 because the decimal part is being removed.
So is there a configuration that can be done to remove the comma from the CSV export?
Hi Gabriel, hope you're good! I have read your question and the anwser above, i think you can change in the setting of excel app hot to handles decimal number and change it to interpret with a "." instead of "," that way your number 12,345 will be read as you want, and 12.345 will be a decimal number.
here is the link to microsoft documentation: Change the character used to separate thousands or decimals - Microsoft Support
From what I understand of the case, the problem is not with the dataminer but with the way Excel handles such data.
Hello Joao, thank you for that information. So is there no way for Dataminer to export the data using the locale settings of the server or to change which separator is used for these numbers? It has to be changed in the Excel app?