I’m a programmer, but there are a few things I’ll admit I don’t do much of (as I have little interest in learning). Playing with numbers in scientific notation is one of them.
I was importing from a spreadsheet and needed to get “6.00234419836431E+15” to something readable.
I discovered that you need to specify a NumberStyle when you parse as a decimal, because by default you’ll get an error as it expects an ‘easy’ conversion.
The number above had decimals, exponent, the lot – so the following line of code does the job nicely…
//Globalisation namespace just shown for clarity – you’ll want to put this in a using statement 🙂
This gives you “6002344198364310”. Sweet.