Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
I am using Execll 2002 and cannot put more than 15 numbers in a cell before
it shortens the numbers. Is there a way of changing how many numerical characters in a cell. -- Neil |
#2
![]() |
|||
|
|||
![]()
Excel only keeps track of 15 digits.
If you can treat the digits as text, you can prefix your entry with an apostrophe: '123451234512345 or preformat the cell as Text first (format|Cells|Number tab) Then type in your entry. NeilC wrote: I am using Execll 2002 and cannot put more than 15 numbers in a cell before it shortens the numbers. Is there a way of changing how many numerical characters in a cell. -- Neil -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how many characters i can put into one cell in Excel | Excel Discussion (Misc queries) | |||
Repeat characters to cell width | Excel Worksheet Functions | |||
limit number of characters in a cell | Excel Discussion (Misc queries) | |||
Can I set the numerical type of Cell to Hex format | Excel Discussion (Misc queries) | |||
#### error if cell has more than 255 characters | Excel Discussion (Misc queries) |