| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
OK so I found a way to find where the valuse should exist but I am still unable to view them? I trimmed down my data set to one version so sumif is unnecesary then used sum(A$1:A1) and copied it down then where ever the value changed I figured there most be a decimal in that value I have the view so that I can more decimals than I should need to in both columns but I still can't view the actual decimal it just displays .0000000000 also the decimal change is in the 12th decimal # thanks for your help -- clane ------------------------------------------------------------------------ clane's Profile: http://www.excelforum.com/member.php...o&userid=11865 View this thread: http://www.excelforum.com/showthread...hreadid=381265 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| decimal places within a formula | Excel Discussion (Misc queries) | |||
| DECIMAL PLACES IN FORMULAS | Excel Worksheet Functions | |||
| Changing default decimal places | Excel Discussion (Misc queries) | |||
| goal seek wont calculate an accurate value past 3 decimal places | Excel Discussion (Misc queries) | |||
| Entering numbers with variable decimal places. | Excel Worksheet Functions | |||
Threaded Mode
