Excel 2013 CSV converting to Dates
I have searched high and low for this answer. Everything I have read says
to format the field to 'text' and that simply does not work.
Ok, when saving my excel sheet in .csv, it decides to convert my text into
dates. I have been trying to figure out how to stop this for hours.
For example:
If I enter 06-3031 into a cell after making the cell format 'text' and
save the file, I can open it back up and that text mysteriously changes to
Jun-31.
I have even tried using ' before I enter the above text. However in that
case, I can save the file and open it back up to only find that cell
empty.
I really hope someone has an answer to this crazy issue.
Thanks!
No comments:
Post a Comment