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

  • Thread starter Thread starter flowers
  • Start date Start date
F

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?
 
flowers said:
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?
Click to expand...


Excel has a limit on the number of digits you can input for one
number....nothing you can do AFAIK.
 
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
 
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
 
Back
Top