I import large numbers via a csv file and recently I noticed that the numbers have become larger and when I import them into Excel, sometimes the number gets truncated and there are zeros at the end of it and it also appears in scientific notation.
How can I make Excel keep the entire number instead of rounding or truncating it and also not show in scientific notation by default?
Ex.
123456789123456789123456789
becomes
1.23456789123456E+26
And
123456789123456789
becomes
123456789123456000
Thanks,
Sam