Excel Droping The Last Number
 

The number in cell A2 is: 91412.700110100. I would like the formula in B2 to
count the number in A2 and add the number of the count to the end of the
number string using 4 decimal digits. Such that the new number equals
91412.7001101000001.

The formula I am using in cell B2: =A2+COUNTIF(A$2:$A2,A2)/10000000000000)

I would like the formula in column B to be able to be pulled down so that it
will count each new number in column A and add the number of the count, up to
9999, to the original number in column A. The key is to add the count to the
number without changing any of the numbers that precede it.

The problem I am having is that excel drops the count number from the end of
the number string so that the string ends with zero. This is definately not
a formatting issue as I have tried various number formats all of which don't
work. Maybe it is a preferences issue that I cannot figure out.

Any advice would be greatly appreciated.

--
iperlovsky

Excel Droping The Last Number
 

Excel can handle up to 15-digit precision. If you need a 16th digit it'd
have to be text, but then arithmetic against this value would not give
accurate results.
Bob Umlas
Excel MVP

"IPerlovsky" wrote in message
...
The number in cell A2 is: 91412.700110100. I would like the formula in B2
to
count the number in A2 and add the number of the count to the end of the
number string using 4 decimal digits. Such that the new number equals
91412.7001101000001.

The formula I am using in cell B2: =A2+COUNTIF(A$2:$A2,A2)/10000000000000)

I would like the formula in column B to be able to be pulled down so that
it
will count each new number in column A and add the number of the count, up
to
9999, to the original number in column A. The key is to add the count to
the
number without changing any of the numbers that precede it.

The problem I am having is that excel drops the count number from the end
of
the number string so that the string ends with zero. This is definately
not
a formatting issue as I have tried various number formats all of which
don't
work. Maybe it is a preferences issue that I cannot figure out.

Any advice would be greatly appreciated.

--
iperlovsky

Excel Droping The Last Number
 

thanks
--
iperlovsky


"Bob Umlas" wrote:

Excel can handle up to 15-digit precision. If you need a 16th digit it'd
have to be text, but then arithmetic against this value would not give
accurate results.
Bob Umlas
Excel MVP

"IPerlovsky" wrote in message
...
The number in cell A2 is: 91412.700110100. I would like the formula in B2
to
count the number in A2 and add the number of the count to the end of the
number string using 4 decimal digits. Such that the new number equals
91412.7001101000001.

The formula I am using in cell B2: =A2+COUNTIF(A$2:$A2,A2)/10000000000000)

I would like the formula in column B to be able to be pulled down so that
it
will count each new number in column A and add the number of the count, up
to
9999, to the original number in column A. The key is to add the count to
the
number without changing any of the numbers that precede it.

The problem I am having is that excel drops the count number from the end
of
the number string so that the string ends with zero. This is definately
not
a formatting issue as I have tried various number formats all of which
don't
work. Maybe it is a preferences issue that I cannot figure out.

Any advice would be greatly appreciated.

--
iperlovsky