How to solve xlsread reading problem ?

I have some dataset in excel and it looks like below:

18597.7  18948  20638.4  21640  10756.9  11650.5  10169.2  10561.4  23345.7  23849.3
9626.39  8904.5  11493.8  10379.2  9502.79  9820.17  10263.6  11049.2  14270.6  12595.5
291.195  219.856  325.569  283.287  334.142  620.478  408.943  367.155  179.294  249.224
1367.97  1529.94  1615.2  1551.5  3998.73  4331  3953.89  3870.35  1155.08  1297.32

Now, whenever I read the file using xlsread, the values turn to this:

 [a b]=xlsread('filename')
 a =

   1.0e+04 *

    1.8598    1.8948    2.0638    2.1640    1.0757    1.1650    1.0169    1.0561    2.3346    2.3849    2.2064    2.5963
    0.9626    0.8904    1.1494    1.0379    0.9503    0.9820    1.0264    1.1049    1.4271    1.2595    1.3032    1.4103
    0.0291    0.0220    0.0326    0.0283    0.0334    0.0620    0.0409    0.0367    0.0179    0.0249    0.0068    0.0157
    0.1368    0.1530    0.1615    0.1552    0.3999    0.4331    0.3954    0.3870    0.1155    0.1297    0.1512    0.1825

What should I do so that I get my values as it is. Why this exponential ?

Answer 1

[Walter Roberson]

Give the command

format long g

and display your data again.

[Anurag Pujari]

Thanks for the answer. But what have this command done? This command must have been mentioned along with the xlsread function description.