detriez
Board Regular
- Joined
- Sep 13, 2011
- Messages
- 193
- Office Version
- 365
- Platform
- Windows
Why does this happen and how can I correct it?
112393000000 appear as 1.12E+11
113000000000 appear as 1.13E+11
113097000000 appear as 1.13E+11
The sheet cell appears as 1.12E+11 but when I click on the cell, it value is 112393000000.
I've tried formatting cells to different formats like these but still didnt fix the issue
General
Number
Text
A workaround is placing an apostrophe ' at the beginning of the cell but is there another way for me to correct or prevent it from happening?
112393000000 appear as 1.12E+11
113000000000 appear as 1.13E+11
113097000000 appear as 1.13E+11
The sheet cell appears as 1.12E+11 but when I click on the cell, it value is 112393000000.
I've tried formatting cells to different formats like these but still didnt fix the issue
General
Number
Text
A workaround is placing an apostrophe ' at the beginning of the cell but is there another way for me to correct or prevent it from happening?