How to do formatting of 8.10574E+12

0
Hi Team, I try to import a value 8105740000000 va excel sheet which takes the value as 8.10574E+12. (The column format is General). The data is imported as 8.10574E+12 in the application . How to format it as 8105740000000 in the application ? Thanks in advance  
asked
1 answers
0

I had this problem before and it seemed to be Excel automatically formatting values.

Could you import ‘8105740000000’ as a string and then run a parse microflow to convert to a decimal / integer? 

Alternatively import as a csv?

answered