How can I use xlswrite to specifically write to a cell as text?

I'm trying to write the string '0E0' to an Excel spreadsheet using xlswrite. However, Excel interprets this as a number in scientific notation. The cell appears as the number 0 in the output spreadsheet, instead of as the text "0E0". There appears to be no way to recover the original text information once in Excel (changing number format to text leaves "0" as a string). I'd like it to remain a string through the xlswrite process, otherwise the information is lost. Is there a way to do this?

Answer 1

[Brian B]

I don't have MATLAB in front if me to test it, but you could try adding a single quote before the string, as in

    xlswrite('a.xlsx', {'''0E0'})

This tells Excel to interpret the value as a string.

[Chris]

Thank you. This is a great response. Simple to implement and comprehensive.

[simith]

thanks in advance

[Nikolaus Koopmann]

thanks 1.2 Billion