How to export negative number to a .csv file using writetable()

Hello,

I tried to export a table contaiing a negative value to a .csv file as follows:

C ={'4 -9'}

T = table(C)

writetable(T, 'filename' '.csv')

I'm getting 09-Apr as output because of the negative 9. How can I fix this issue directly in Matlab.

[Stephen23]

"I tried to export a table contaiing a negative value to a .csv file as follows:"

But your example shows you exporting some text, no negative numeric values are involved.

C = {'4 -9'};
T = table(C);
writetable(T, 'test.txt')
type test.txt

C
4 -9

"I'm getting 09-Apr as output because of the negative 9."

No, you are getting "09-Apr" because you made the mistake of opening a text file using MS Excel.

"How can I fix this issue directly in Matlab."

How can MATLAB "fix" problems caused by MS Excel's dodgy importing algorithms? (hint: no one can)

https://www.theverge.com/2020/8/6/21355674/human-genes-rename-microsoft-excel-misreading-dates

[Joel Olenga]

Thanks!