Dec 29 2017
12:34 AM
- last edited on
Jul 25 2018
10:38 AM
by
TechCommunityAP
Dec 29 2017
12:34 AM
- last edited on
Jul 25 2018
10:38 AM
by
TechCommunityAP
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
Dec 29 2017 03:45 AM
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.