formatting exponential

Question

Hello,
I am ingesting data into delta parquet using dataflow in data factory...
One of the columns, column1 sometimes has values such as:

Column1
--------
35. 5
1E-07
0. 9
...

Question:
Whilst ingesting, how can I convert the exponential to a number?

Thank you

Answer 1

how can I convert the exponential to a number?

You get already numeric values (!!!), even if they look like in scientific format in your frontend (which ever you use); so what do you what to convert here?

https://en.wikipedia.org/wiki/Scientific_notation