How can I avoid having data proccesed in MATLAB with dots? I have to transfer the data to excel and manually replace later with commas.

How can I avoid having data proccesed in MATLAB with dots? I have to transfer the data to excel and manually replace later with commas. Is there an option for MATLAB to deliver me the data with commas already?

[dpb]

Do you mean ',' for decimal point instead of the US '.'?

AFAIK there's no way to use the comma as a decimal separator inside Matlab, you could do a string substitution and write a file using them, however. It would require making the substitution on an internal write in memory and then writing the string to the file, however; there's no facility to use the ',' as the decimal point automagically.

Answer 1

[Wayne King]

When you say "dots" do you the decimal point? Why can't Excel handle a decimal point?

If it's a matter of replacing a decimal point with a comma, you can do that after converting the number to a string.

x = 2.31;
 strrep(num2str(x),'.',',')

If I've misunderstood your question, can you clarify?

Answer 2

[Azzi Abdelmalek]

a=rand(10,2) % example
b=strrep(arrayfun(@num2str,a,'un',0),'.',',')
xlswrite('file50.xls',b)