String with "E" interpret exponentiel

Hazou
Hazou Registered Posts: 7 ✭✭✭✭

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

Best Answer

Answers

Setup Info
    Tags
      Help me…