| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel. How to round a number to nearest half number? | Excel Discussion (Misc queries) | |||
| Excel file opens with a colon followed by a number in the Excel Title Bar | Excel Discussion (Misc queries) | |||
| Excel: How do I count the number of pictures in an excel cell? | Excel Discussion (Misc queries) | |||
| convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
| excel format cells/Number/Category: Number problem | Excel Discussion (Misc queries) | |||
Hybrid Mode
