[
I'm using Excel 2016
I got the following 2 numbers in excel:
27837837879
and 2.79602E+14
(I can see the full number in the function panel as per attachment 279602001944127, also if I expand the column, it still has the number converted to exponent)
These two cells by default are formatted as general. If I now format as text, it still shows as exponential however if I format as number and make the decimal place 0, then only does it show the full number.
One would expect the general and text format to show the full number not the exponential number. I really think its a bug.
If its not treated as a bug, then at least when I format cell as general, it should have further options to not display numbers as exponential.