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.


Comments

Popular posts from this blog

Load Balancing in Bluemix using custom domain and DNS SRV records -

oracle - pls-00402 alias required in select list of cursor to avoid duplicate column names -

python - Consider setting $PYTHONHOME to <prefix>[:<exec_prefix>] error -