Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
try to enter normal number but get this instead 9.10115E+21
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? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
try to enter normal number but get this instead 9.10115E+21
"flowers" wrote in message
... 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) |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
try to enter normal number but get this instead 9.10115E+21
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" wrote in message ... 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? |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
try to enter normal number but get this instead 9.10115E+21
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? |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
try to enter normal number but get this instead 9.10115E+21
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why am I getting ### when I enter an accting number and hit enter | New Users to Excel | |||
Automatic job id number once enter a row | Excel Worksheet Functions | |||
How do I enter formula using % > or < = number? | Excel Worksheet Functions | |||
how do i sought coloured number cells from normal ones? | Excel Discussion (Misc queries) | |||
You Must Enter A Number In This Cell | Excel Discussion (Misc queries) |