How to xlswrite cell array with both strings and number?

I have a cell array of the type A={'01:02:03'};

when I use the function: xlswrite('Output',A)

The excel sheet that I get has eliminated the first zero, it is reading the cell as a number and giving me output as '1:02:03'. How do I get the entire string without eliminating 0?

Answer 1

[Azzi Abdelmalek]

A={'''01:02:03'};

[Supreet Hegde]

I have cell array of size 2000*15 of such data. What should I do in that case?

[Azzi Abdelmalek]

Look at this example

s={'01:02:03';'01:02:03';'01:02:03'}
a=strcat('''',s)
xlswrite('fic.xlsx',a)

[Supreet Hegde]

Sorry Azzi, I forgot to mention that my data has few numbers too. And those numbers are being output as some random symbols. Is there a way out?

[Azzi Abdelmalek]

s={'01:02:03';11; 20; '01:02:03';'01:02:03' ;11 ;10 }
idx=cellfun(@isstr,s)
s(idx)=strcat('''',s(idx))
xlswrite('fic.xlsx',s)

[Supreet Hegde]

This works great! Thanks a lot!

Answer 2

[Carl Agnew]

Change the cell format in excel to "Text".

[Supreet Hegde]

I have tried doing that. It didn't work.