I download spreadsheets from a web site that have dates in this format:
Oct 1 2003 12:00AM
On some of the spreadsheets I can use the text-to-column to convert the text dates to Excel dates, but on other spreadsheets it refuses to work. I noticed that sometimes the spreadsheets come down as html rather than xls files, but they still look like xls files. I thought that might be the problem, so I saved the file as an xls file, but I still can't convert to dates using text to column. I then copied the columns with the dates to a new spreadsheet. They still won't convert. What's going on that could make the spreadsheet behave this way and how can I get the dates converted using text to column. I know I can use formulas, but because I have to do this frequently, I'd like to know why I can't convert and how to fix it.
Thanks.
Oct 1 2003 12:00AM
On some of the spreadsheets I can use the text-to-column to convert the text dates to Excel dates, but on other spreadsheets it refuses to work. I noticed that sometimes the spreadsheets come down as html rather than xls files, but they still look like xls files. I thought that might be the problem, so I saved the file as an xls file, but I still can't convert to dates using text to column. I then copied the columns with the dates to a new spreadsheet. They still won't convert. What's going on that could make the spreadsheet behave this way and how can I get the dates converted using text to column. I know I can use formulas, but because I have to do this frequently, I'd like to know why I can't convert and how to fix it.
Thanks.