Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
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.
Since it's Excel that is interpreting 6E040 as a number, you could also check how to get Excel to stop automatically converting your data in order to keep it as a String.
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...