This question already has an answer here:
I am trying to edit a csv file in excel, but am running into issues with its supposedly-helpful automatic format detection, and I don't know how to turn it off.
I have a field with an original value "28:55". Excel converts this immediately on loading the file into "28:55:00", thinking it needs to be in hh:mm:ss format. When I try to manually convert the format back to a string, it inexplicably transforms into "1.204861111".
How do I turn off this automatic data conversion when loading a file? I haven't been able to find anything helpful in the excel settings.
: This is Excel 2010. All online resources I have looked at just tell you how to stop automatic conversion once a file is loaded, not how to stop the conversion that happens during Excel's initial reading of the data.