| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does last number of a 16 character number always change to 0?
When entering large numbers of approximately 16 characters or more into a
column, why does the last number automatically become a zero even when I type a different number in? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why does last number of a 16 character number always change to 0?
15 digits is the limit.
"FALCON" wrote: When entering large numbers of approximately 16 characters or more into a column, why does the last number automatically become a zero even when I type a different number in? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why does last number of a 16 character number always change to
15 signigificant digits. If you want to see all 16 format as text or precede
with ' (apostrophe) -- Kevin Vaughn "JMB" wrote: 15 digits is the limit. "FALCON" wrote: When entering large numbers of approximately 16 characters or more into a column, why does the last number automatically become a zero even when I type a different number in? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I Need a formula to evaluate a cell with + or - values | Excel Worksheet Functions | |||
| Change cell color if it is the lowest number of a group? | Excel Discussion (Misc queries) | |||
| Change number when you open the excel template | Excel Discussion (Misc queries) | |||
| How do I change the invoice number assigned in Invoice template... | Excel Discussion (Misc queries) | |||
| EZ Q 4 U: How do I change a number to text, based on the number | Excel Worksheet Functions | |||
Hybrid Mode
