- last edited on
While using excel if i type this digit in any cell 2017272505089170001 i get the number as
how can i change this to get the number that i want to type. file attached
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 here.
It suggests stopping Excel from changing large numbers to scientific notation.I advise you to vote for it.