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]

"flowers" <flowers@discussions.microsoft.com> wrote in message
news:018F1097-9204-4F5F-B1F6-81CBB87C379A@microsoft.com...
> 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.

--
Asking a question?
Please tell us the version of the application you are asking about,
your OS, Service Pack level
and the FULL contents of any error message(s)

[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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"flowers" <flowers@discussions.microsoft.com> wrote in message
news:018F1097-9204-4F5F-B1F6-81CBB87C379A@microsoft.com...
> 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?

[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
--
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?

[Bernard Liengme]

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" <SulemanPeerzade@discussions.microsoft.com> wrote in
message news:98486EDA-AC70-4602-AD20-A727C494A730@microsoft.com...
> 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
> --
> 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?