Excel 2013 converts text to dates in csv comma separated file -

i editing csv comma separated file in excel 2013.

when enter 6/60 in column, excel turns jun-60 , don't want that.

i've tried:

1. choosing "text" in "cell format" options. save changes , close program. when open file have: jun-60

2. pasting values. save changes , close program. when open file have: jun-60

3. entering '6/60. save changes , close program. when open file have: jun-60
4. entering "=""6/60""". save changes , close program. when open file have: "=""6/60"""

i had combined options. not working.

any ideas?

please remember editing csv comma separated file in excel 2013 not xlsx format.

thanks!

how this:

use own option 1. not re-open file file menu, import data (data-tab, text). on last page of wizzard, choose 'text' column data format. should work.