save matrix in excel and keeping the configuration (. and ,)

Hello,

I am trying to save a matrix from MATLAB as CSV (or excel) however I am facing the following problem..

The number 0.98 (matlab matrix) is saved as 0.98 (CSV table) -> correct

The number 1.05 (matlab matrix) is saved as 105 (CSV table) -> Wrong

The number 1.08679 (matlab matrix) is saved as 108.679 (CSV table) -> Wrong

I am atatching the two imagens from MATLAB and CSV.

[Emmanuel J Rodriguez]

Hi! I'd like to take a closer look and see if I may be of help. Can you share the code?

[Stephen23]

By default MS Excel aligns text of the left and aligns numbers on the right... which tell us that (if you haven't changed the alignment) something is really messed up with how MS Excel interprets that data file.

However because you did not upload your data (both MAT file and CSV file) by clicking the paperclip button there is not much we can do.

Answer 1

[Amanjeet Pani]

you can run this command using matlab

writematrix(<matrix_name>,'filename.xls')

Aditionally you can go through this documentation page of writematrix() of matlab for more details if any.