I have one colum (String) with this value '6E040', when i export dataset to excel, this value is 6000000...
Excel interpret E as exponentiel.
I tried with recipe prepare to add quote (concat('"', column, '"')), but it's not working because i have this result "6.0E40" .
Someone can help me.
When importing data into Excel, you can prevent it from formatting it.
I suggest to have a look at the second solution here (not the accepted one) : https://superuser.com/questions/330291/how-to-stop-excel-from-auto-formatting-and-making-it-work-lik...