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
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