Cell formats in CSV keep reverting to dates

[hens10]

Greetings
A CSV input sheet for a matlab application requires a row of text in the text format = mmmyy.
Whenever I open this sheet in excel in order to edit other parts of the file, excel changes that row of text to a date format mmm-yy. This means each time I open the file, I must convert the row of dates back into text using =TEXT(date, "mmmyy"), pasting over as values etc.

Is there a way to stop excel recognising this row of text as a date?

Thanks

 

[RoryA]

Assuming you have to keep using Excel to edit it, you should simply be able to change the format of that column back to mmmyy and then save as CSV again.