Forum Discussion
How to Prevent Excel from Auto-Converting String to Date
Hello. I have some product data with product codes like "07-2772", "12-2773" etc. If you type these strings in Excel, it'll automatically convert "07-2772" to Jul-72 and "12-2773" to Dec-73 as dates....
Instead of double-clicking the .csv file, open it from within Excel.
This should activate the Text Import Wizard.
In Step 3 of this wizard, you can specify that some columns must be treated as text.
Got it. Thank you for your help!