I have a .csv file I imported. The numbers are 2.26751E+29. When I change them to Number this is what I get- 23461226400000500000000000000.00 With this series of numbers the highest number of digits is 16. I want to get rid of all the zeros after the 16th digit and the decimal and 2 digits. I haven't found the right combination to make this happen. I tried custom number with 16 zeros yet didn't get what I'm looking for. Below is what I want to accomplish.
2346122640000050
Thanks, in advance, for your help.
Vivian
Bookmarks