Problem reading double array from excel

Hi, Im reading data from a excel file and I have a few strings that I need to read it as double and I cant, I tried converting the cell to string and then to double and more options but the result are NaN or not a double. Here is what I need to do:

Here I have the excel value

This is how I read all this value and the others (the other values are just normal numbers, so I dont have problems)

This is what I want to do

Thank you for the help

Answer 1

[Stephen23]

READCELL et al import text as text, not as double. You could use STR2NUM on the text:

C = readcell(..)
N = str2num(C{1})

[Stephen23]

str2num('[0:100:100000]')

ans = 1×1001

0 100 200 300 400 500 600 700 800 900 1000 1100 1200 1300 1400 1500 1600 1700 1800 1900 2000 2100 2200 2300 2400 2500 2600 2700 2800 2900

[Daniel]

Ok, that works, I tried str2double (I think is the same) but without the {1}, thank you.

Answer 2

[KSSV]

REad about readtable

[Daniel]

I tried with readtable and readmatrix but not working.

[KSSV]

Attach your excel file.