I have a CSV student responses to questions on a math test. Some of the answers are input as fractions (3/5, etc.) When I open in excel, these fractions get converted to dates. If I change the format back to text or number, Excel changes it into its date code, instead of its value (3/5 becomes 45329 instead of .6 or 3/5) which is obviously not what I need. I have no control over the source data. Is there a way I can stop Excel from autoconverting 3/5 to date when I first open the file? I have Excel 2013.
Solved by B. U. in 30 mins