importing excel into matlab

I am pretty new to MATLAB, I have these two questions: 1.I want to import two columns of excel spreadsheet into MATLAB. After importing it the cells which had No Value had been set to zero in MATLAB. what can I do to make all those zero values to NaN value?

2. I would like to calculate the median value for every 61 rows, what is the command for this?

Thanks

Answer 1

[Star Strider]

1. See the xlsread function.

2. That is a bit more difficult. The usual technique is to use the reshape function to sort the array into (in this instance) a (61xN) matrix (the vectors have to be an integer multiple of 61 rows for this to work), the taking the median of the columns.