When I try to convert Large number (ex: 8996609817110286118) from General to Number, the result becomes: 8.99661E+18 ( 8996609817110280000), It forces this approximation, which I don't want)
1 Answers
There's no exact number representation in excel for numbers this big. You can either use strings instead of numbers (see this post), or live with the reduced accuracy. You did not specify what these numbers represent, but there are almost no applications that require physical quantities to be that accurate.
Related