Hi Excel Experts,
I am stuck in an sorting issue. I wanted to sort just the text date cells, which is located in a Date Column. so that i can correct them, by using Text to column procedure. These i come across as i get report in .csv format, which i import to excel.
If i do Text to column, by selecting whole column, it also crisscrosses/messes the dates which are showing proper date & month. There are 15000+ rows, plus many sheets. Need help in selecting just TEXT DATE Cells by macro/code, so that i can apply below TEXT to column just for this Text Date.
Attached an Excel file as a Sample, Please see EUR TAB (G COLUMN), which is of original file.
Thanks a lot in advance.
TEXT Dates to Sort by Macro.jpg
____
If the dates are text from a CSV file and look like 4/15/2015 and NOT 4-15-2015 you can use Text to columns.
1. Select the dates
2. Click on the Data Tab, Text to columns
3. Click Next, Next, select Date and DMY
4. Click Finish
The dates will be converted to the regional settings for dates.
Regards
Ram
Bookmarks