Question
Readexcel
Readexcel not transferring correct values for scientific notation. Below are example of change in the exponent from before to after;
Before After
| -4.30E-07 | -4,30E-05 |
| -4.26E-07 | -4.26E-05 |
| -4.13E-07 | -4.13E-05 |
| -3.92E-07 | -3.92E-05 |
| -3.62E-07 | -3.62E-05 |
| -3.23E-07 | -3.23E-05 |
| -2.77E-07 | -2.77E-05 |
| -2.22E-07 | -2.22E-05 |
| -1.58E-07 | -1.58E-05 |
| -8.67E-07 | -8.67E-04 |
| -6.96E-07 | -6.96E-05 |
| 8.08E-07 | 8.08E-04 |
This results in a curve like this: I have found no way to correct the exponents on the two extreme points. The curve should be smooth.


