String with "E" interpret exponentiel

Solved!
Hazou
Level 1
String with "E" interpret exponentiel

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

 

 

 

0 Kudos
1 Solution
MarcH
Dataiker

Hello,

This formula should work for your case: concat('"', strval('column'), '"')

View solution in original post

4 Replies
MarcH
Dataiker

Hello,

This formula should work for your case: concat('"', strval('column'), '"')

Hazou
Level 1
Author

Thank you MarcH, 

Do you have an other solution ?  because i don't really want to add quotes. 

0 Kudos
MarcH
Dataiker

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.

0 Kudos
VFL
Level 2

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...

0 Kudos