Forum Discussion
Excel formatting for long numbers
When entering long numbers (ex: 9114902307224014945528), Excel converts this to "9.11490230722401E+21". I have tried reformatting the cells and even opened a blank/new spreadsheet. No difference. ...
Those values are larger than Excel can handle and display with full precision; see Understanding Floating Point Precision, aka “Why does Excel Give Me Seemingly Wrong Answers?”
I hope that Joe User will explain it in more detail.
- Thanks!
