Not is more than 15 digits are entered!
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Suleman Peerzade" wrote in
message ...
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?