Why does XLSREAD read wrong values for certain negative numbers?

Why does XLSREAD read wrong values for certain negative numbers?

For example, consider an Excel file that has the following values:

       -112.40

       -23071.36

       -23072.36

       -23088.3

       -23130.67

       -23131.42

       -23153.65

Using XLSREAD on the above XLS file, say test.xls yields the following results:

        a = xlsread(['test.xls'])

       a =

         1.0e+007 *

         -0.00001124000000

         -0.00230713600000

          1.07143458800000

          1.07143299400000

          1.07142875700000

          1.07142868200000

          1.07142645900000

Answer 1

[MathWorks Support Team]

This was a bug in MATLAB 6.0 (R12)which has been fixed in MATLAB 6.1 (R12.1).

There are no known workarounds for MATLAB 6.0 (R12)