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:
choosing "text" in "cell format" options. save changes , close program. when open file have: jun-60
pasting values. save changes , close program. when open file have: jun-60
- entering '6/60. save changes , close program. when open file have: jun-60
- 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
Post a Comment