HOW TO REMOVE QUOTE MARK ?

I have a data (4259*1 cell ) ex: '9'

I want to remove the quotes mark

i try :

 j=1;
for i=1:R
        D(j)=t{i};
        j=j+1;
end
w=D';

but its fake remove them as when i try to use the numbers or copy to excel the quotes appear again

how to remove the quotes or convert them to (4259*1 double)?

[Image Analyst]

Show your code. It looks like you're trying to do something with xlswrite('vital signs.xlsx'.....) but we can't see it. What do you want? Do you want to write t, D, or w to a workbook file? And you want the workbook file to be numbers, not strings with quotes in front of them?

Answer 1

[Kirby Fears]

Hi amr,

You shouldn't be copying the values out of the variable editor like that.

Try using

xlswrite('output.xlsx',t);

This will directly write the values to excel for you without parentheses.

Hope this helps.

[Amr Hashem]

thanks kirby ... it works

Answer 2

[Jon]

What happens if you try

tnum = str2num(cell2mat(t));

[Walter Roberson]

str2double() is better than str2num()

[Amr Hashem]

an error:

 Error using ==> cell2mat at 55
Cannot support cell arrays containing cell arrays or
objects.

Answer 3

[Walter Roberson]

str2double(t)

[Amr Hashem]

it converts all cells to NAN

(4259*1 double ) but all are NAN