Query on scientific notation

[DanielCarro]

Hi,

I have a situation with scientific number

I used the formula tool : 

ToNumber([Field])

but for some reason it works for some but others it doesn't .

Any suggestions to make the calculation work for all of them.

Kind Regards,

Dan

[gabrielvilella]

Using the ToNumber on a regular formula tool will not change the data type of an existing field. You need to change the data type using the Select tool (type Double) or with the Multi-field formula.