Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Hello,
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.
Thank you
Hello,
This formula should work for your case: concat('"', strval('column'), '"')
Hello,
This formula should work for your case: concat('"', strval('column'), '"')
Thank you MarcH,
Do you have an other solution ? because i don't really want to add quotes.
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...