I have the code to open a .CSV file but when the file opens, it is converting some of the data, not all, to a date. As example, one of the cell values in column A is '5MAR'. When the file is opened, it is being converted to 03/05/2012. I need to leave this cell as '5MAR'. In other words I need to keep both columns in a text format. I did try to convert the columns to text after the file was open but it only proceeded to convert those cells to number. Any assistance appreciated. Thanks![]()
Prompt = "Select the data file to process." Path = Application.GetOpenFilename("Text Files (*.csv*), *.csv", , Prompt) Set wkbData = Workbooks.Open(Filename:=Path, ReadOnly:=True)
Bookmarks