It was there, the problem is that by default if you open files the way most people do (double-clicking or dragging) then Excel decides you must not want to be bothered by the options so it fills them in for you. "Helpfully" not even using the most basic inference to assign types in a way that doesn't destroy the data.