News

Excel will keep them intact. Similarly, if you input data that might be interpreted as a date, such as "05-11," formatting the cell as text prevents it from being automatically changed to a date ...
Pro tip: Never change the format of a cell with a date to General or Text. Excel will turn your date into an unrelated number. For example, 3/3/2017 becomes 42797 when it's not formatted as a date.