I have a long list of numbers in Column J (example below):
58
24
3499999999999990
43
50000000000001
40000000000006
However, these super long numbers are coming up as things like:
5E+13
4E+13
9.9E+14
1.4E+14
I want to just round these numbers so that they'll only show the first 3 digits. I thought about using a LEFT formula but this wouldn't work for where the number is only 2 digits long and doesn't need cutting down.
Does anyone please have any suggestions? Thank you!
Bookmarks