Saving strings (ex. 0222222) from MATLAB to Excel using xlswrite is saving as a numeric.

Hello,

I am trying to save a string (i.e. 02222222) into excel. I need to keep the leading zero, but when I use xlswrite in MATLAB is converts it to a number, so I lose the leading 0.

I currently have my data saved in a cell array as a string.

Any clue if this is possible?

[Rik]

Have you tried wrapping the values in double quotes? Excel has a tendency to be smart-ass and change the data type if you don't include " to denote strings.

[Dankur Mcgoo]

As in in front of the number (ex. "02222222)?

Answer 1

[Fangjun Jiang]

Add a single quote in front to deal with Excel

a={'"022','''022','022'}
xlswrite('test.xls',a);
winopen test.xls