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