Spratt_Cary
01-29-2008, 04:45 PM
I have a question with formatting a excel spreadsheet. First, I export data into the spreadsheet (hundreds of entries). All the data is in format "TEXT", even the dates.
Question 1 - Is there a easy way to format the columns that contain dates?
I have used "convert" and selected the column, went to format to a date field, but then it appears that I have to double click on each cell for the formatting to be true. I know this is probably simple, but I cannot find the solution.:banghead:
If you look at the attached example, Sheet 1056, column K and M has some individual cells (date format) and some cells that are formatted to "Text"
Any help with converting the text dates to date dates will be greatly appreciated.
Question 1 - Is there a easy way to format the columns that contain dates?
I have used "convert" and selected the column, went to format to a date field, but then it appears that I have to double click on each cell for the formatting to be true. I know this is probably simple, but I cannot find the solution.:banghead:
If you look at the attached example, Sheet 1056, column K and M has some individual cells (date format) and some cells that are formatted to "Text"
Any help with converting the text dates to date dates will be greatly appreciated.