software

I'm using Excel 2000 and need to use 16 digit numbers. However I find that
the last digit automatically changes to a zero. For instance typing
5434603057707214 to a cell is changed to 5434603057707210 when I hit enter.
Is there a way to stop this?

On Fri, 7 Apr 2006 03:25:01 -0700, Trumpeter
gt; wrote:

gt;I'm using Excel 2000 and need to use 16 digit numbers. However I find that
gt;the last digit automatically changes to a zero. For instance typing
gt;5434603057707214 to a cell is changed to 5434603057707210 when I hit enter.
gt;Is there a way to stop this?

If you look in HELP under specifications, you will see that Excel's precision
is fifteen digits.

If these 16 digit numbers are account numbers, or some kind of value upon which
you do not need to do calculations, then you can enter them as text. Either
pre-format the column as text, or precede your entry with a single quote
'1234567890123456--ron

quot;Trumpeterquot; gt; wrote in message
news
gt; I'm using Excel 2000 and need to use 16 digit numbers. However I find that
gt; the last digit automatically changes to a zero. For instance typing
gt; 5434603057707214 to a cell is changed to 5434603057707210 when I hit
gt; enter.
gt; Is there a way to stop this?

Yes. Format the cell as text before you enter the number.
--
David Biddulph
Many thanks, I'll just have to split the number into two columns and do the
maths that way. I did look in help but it seems I chose to aske the wrong
question!

Ian

quot;Ron Rosenfeldquot; wrote:

gt; On Fri, 7 Apr 2006 03:25:01 -0700, Trumpeter
gt; gt; wrote:
gt;
gt; gt;I'm using Excel 2000 and need to use 16 digit numbers. However I find that
gt; gt;the last digit automatically changes to a zero. For instance typing
gt; gt;5434603057707214 to a cell is changed to 5434603057707210 when I hit enter.
gt; gt;Is there a way to stop this?
gt;
gt; If you look in HELP under specifications, you will see that Excel's precision
gt; is fifteen digits.
gt;
gt; If these 16 digit numbers are account numbers, or some kind of value upon which
gt; you do not need to do calculations, then you can enter them as text. Either
gt; pre-format the column as text, or precede your entry with a single quote
gt; '1234567890123456
gt;
gt;
gt; --ron
gt;