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