Set a row100 columnA to 1 Set a row 101 columnA to 0.00000001 Set row 99 to =A100-$A$101
Pull A99 upwards to A0 Display the results at 20 decimals Format the numbers to 20 decimals At and above A89 the result is invalid. This can be corrected by changing A100 to =TRUNC(A100-$A$101; 20) Thank you for your attention PS I tried but could not use Bugzilla. [email protected]<mailto:%[email protected]>
