Question

Converting large numbers

+3

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?

+47

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

Community Stats