Hello,
I have an Excel-file where one of the attributes contains large numbers such as 3.0230003003349996e+19.
I want these numbers to be in a format without the e-notation such as 30230003003349996. What's the fastest way to do this?
Page 1 / 1
Hmmm, you mean the actual number 30230003003349996000? Or you just mean to chop of the "e+n" as it if were a string?
If you just want to keep the number and keep it in excel you can set a custom format in the output like here:
If you are finding you're losing precision you might need to convert the numbers to a string
You can use a StringFormatter with something like this:
For "num" = 3.0230003003349996e+19 it returns 30230003003349995520