Why Excel turns 3-4 into a date and how to prevent it
Which values become dates?
Excel guesses types from entered values. Patterns such as 3-4, 1/2 and 2024-05 can be interpreted as dates, even when they represent product codes, sizes or categories. Dates are stored as serial values, making the original spelling difficult to reconstruct.
Make Excel read the value as text
First, prefix a manually entered value with an apostrophe; it will not appear in the cell display. Second, set the cell format to Text before entering values. Third, import CSV through Data → From Text/CSV and set the column type to Text. Double-clicking the file gives you no opportunity to choose before conversion. Fourth, avoid inserting spaces into codes: those spaces can cause errors in downstream systems.
If it has already been saved as a date
The original spelling may no longer be stored in the file, so exact restoration is difficult. Prevent future conversion by importing the relevant columns as text. The Loopyti Prevent Excel Data Loss: CSV Value Check can find strings that risk being interpreted as dates.