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 attached
thank yo
1 Reply
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.
