Please Note: This article is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003. If you are using a later version (Excel 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Excel, click here: Stopping Date Parsing when Opening a CSV File.
by Allen Wyatt
(last updated July 4, 2019)
Marc has a user at his company who is trying to open a .CSV file in Excel. Some of the numbers in the file are in the format of "2-1" (or something similar). During the import, Excel parses this information as a date. If the piece of data is clearly something outside a valid date range (such as 2-134), then Excel imports it as would be expected. Marc is wondering how his user can force Excel to not parse this data as dates but to import them as text fields.
There at two easy ways you can approach this issue. First is to import the file in the following manner:
Figure 1. The Text Import Wizard.
The other way to approach the issue also involves the Text Import Wizard, but how you display it is different. In this approach, you use Windows to rename the file so that it has a .TXT extension instead of a .CSV extension. Now, when you use Excel to open the file, it displays the Text Import Wizard because it isn't quite sure how to interpret what it is going to be loading. You can use the Text Import Wizard in the same manner as already described earlier in this tip.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (3228) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Stopping Date Parsing when Opening a CSV File.
Comprehensive VBA Guide Visual Basic for Applications (VBA) is the language used for writing macros in all Office programs. This complete guide shows both professionals and novices how to master VBA in order to customize the entire Office suite for their needs. Check out Mastering VBA for Office 2010 today!
Not all data is created in Excel. Indeed, you may have data in files created by many other types of programs. You might ...Discover More
If you use UNC paths in your links to external information, those paths may need to be changed at some point. You can ...Discover More
Wouldn't it be nice to have a single command that would save each of you open workbooks, all at once? It's easy to do ...Discover More
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.