How to get value from cell

I have a cell like this:

...

'ITEM:'

'0'

'ITEM:'

'75'

'ITEM:'

'-0.0001174'

'2.1593e-005'

'-10'

'ITEM:'

'167'

'216'

'215'

'268'

'269'

...

I want to get value from '167' to '269' in number (NOT in string) Which command can be used? Give the code is helpful.

Answer 1

[TastyPastry]

 str2double(myCell{index});

index is whatever index the data you need to convert is. If you need to run this command on all cells (looping or something of that sort), you'll need to be aware that str2double() returns NaN for strings which are either non-numeric or are multiple numbers.

Answer 2

[Walter Roberson]

str2double()