How do you remove/correct scientific notations?

[vlruch67]

How do you remove/correct scientific notations? I have tried changing to numeric but it does not give the correct number. For example: 

6.50E+11

 It shou;d be 650466000000 but it changes it to 650000000000

[Akshay1]

Hello vlruch,

Try doing a split on the column with Scientific values on the "+" Value and then use a compute function to create a multiplier that gives you the appropriate value for 6.50E+11. I hope this helps.

Thank You,
Akshay

[Melanie]

Vlruch, if you need guidance on your compute function options, you can find docs on the supported functions here:
https://paxata.atlassian.net/wiki/spaces/PaxDocs/pages/539787313/Supported+Functions