Forum Discussion
Help on input of number in excel cell
Hi,
While using excel if i type this digit in any cell 2017272505089170001 i get the number as
2.01727E+18
how can i change this to get the number that i want to type. file...
Go to Home Ribbon tab >> Number Group
Then choose the Number format from the combo box.
In short, select the number and press Ctrl+Shift+1
There is an idea related to this topic found https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/10374741-stop-excel-from-changing-large-numbers-actually.
It suggests stopping Excel from changing large numbers to scientific notation.
I advise you to vote for it.