15 numbers in a cell

's Computer Specifications

Can you increase the maximun amount numbers in 1 cell to greater than 15???

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
add multiple numbers in one cell with those numbers remaining visi	TD	Microsoft Excel Worksheet Functions	7	28th May 2009 09:41 PM
how to extract numbers from imported cell with text and numbers?	=?Utf-8?B?anlpbg==?=	Microsoft Excel Misc	3	28th Mar 2007 01:14 PM
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?	C-Man23	Microsoft Excel Worksheet Functions	3	19th Jan 2006 09:52 AM
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?	C-Man23	Microsoft Excel Worksheet Functions	1	9th Jan 2006 01:23 PM
filtering out a string of numbers out of a cell with text and numbers	brucejd	Microsoft Excel Misc	2	6th Aug 2004 12:03 AM