Select the range of the cell you want to enter the data into and then right
click formattingGeneralOk

That should solve your problem
--
Thanks
Suleman Peerzade


"flowers" wrote:

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?