| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
15 numbers in a cell
Can you increase the maximun amount numbers in 1 cell to greater than 15???
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
15 numbers in a cell
To get more than 15 significant digits you need to make the cell text by
either formattting the cell as text and re-entering the number or preceed the number with an apostrophy '. 15 digits is a limit of your PC and not XL specifically so there is no easy way around it. There are some addins that will allow you to use more the 15 digits but there is a bunch of overhead associated with doing that... -- HTH... Jim Thomlinson "jas" wrote: Can you increase the maximun amount numbers in 1 cell to greater than 15??? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selecting specific numbers from a cell containing multiple numbers | Excel Worksheet Functions | |||
| how to extract numbers from imported cell with text and numbers? | Excel Discussion (Misc queries) | |||
| Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
| Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
| Populating a cell with numbers without numbers being formula-based?? | Excel Programming | |||
Linear Mode
