try to enter normal number but get this instead 9.10115E+21

[flowers]

I'm trying to make a list of delivery confirmation numbers but when I put the
number in it automatically changes it to 9.10015E+21. I also tried a
different format but it just changed the numbers at the end to all 0000000.
How can I just get it to show the whole number I type in?

 

[Gordon]

I'm trying to make a list of delivery confirmation numbers but when I put
the
number in it automatically changes it to 9.10015E+21. I also tried a
different format but it just changed the numbers at the end to all
0000000.
How can I just get it to show the whole number I type in?

Excel has a limit on the number of digits you can input for one
number....nothing you can do AFAIK.

 

[Bernard Liengme]

What you are entering is not really a number (no math will ever be done on
it); it is just a string of digits. So enter it by:
a) first formatting the cell as Text
OR
b) preceding it with a single quote (apostrophe) as in '91011523456 to make
it text; the quote will not show in the cell, nor will it be printed.
best wishes

 

[Suleman Peerzade]

Select the range of the cell you want to enter the data into and then right
click>> formatting>>General>Ok

That should solve your problem

 

[Bernard Liengme]

Not is more than 15 digits are entered!