Help on input of number in excel cell

[michael samson]

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

[#2]

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.