How Excel turns product codes like 1-2 into dates, and how to import CSVs safely
When a CSV is opened by double-clicking, Excel can automatically interpret product codes such as 1-2 as dates, so they appear as January 2. The file itself remains intact, but once a cell has been converted, changing its format to Text does not restore the original code. CSV files store no type information, so Excel guesses each cell's type, and patterns of digits and hyphens are misread as dates. The recommended fix is to import the file via Data > From Text/CSV, set the code column to Text in the Power Query Editor, and then load it. Users should also avoid overwriting the original CSV, since that would permanently replace the codes.
This is an AI-generated summary. ShortSingh links to the original source for the complete article.

Discussion (0)
Log in to join the discussion and vote.
Log in