Try format cells - custom format d-mmm-yy
I have also faced this problem in the past. Here is what I had done.
1. select the column where you are having date
2. Go to "Data" tab
3. Choose "Text to column"
4. Choose "Delimited" from the pop-up
5. Click "Next"
6. Uncheck all (tab, semicolumn,comma,space & other)
7. Click "next"
8.From "Column data format" select "Date"
9. Select "DMY"
10. Click "Finish"
You might wonder why I said the above 10 steps. This is to transform the column to proper date format. Now you can format it as you want. In your case
11. Select the column with date
12. Go to "Format" & select the type d-mmm-yy
13. Click "Ok"
Hope this helps
A few additional comments on this approach that might save you a few mouse-clicks.1. select the column where you are having date
2. Go to "Data" tab
3. Choose "Text to column"
4. Choose "Delimited" from the pop-up
5. Click "Next"
6. Uncheck all (tab, semicolumn,comma,space & other)
7. Click "next"
8.From "Column data format" select "Date"
9. Select "DMY"
10. Click "Finish"
In your case, you would need toHi,
I have a similar issue with re-formatting the date column from Mar 05 2015 to 5/3/2015. I tried Format cells, I used the format painter and I also tried the steps you listed in the workflow above. It simply would not update the date format.
Alsooneo
In your case, you would need to
- remove Space from the Delimited options, if it is marked
- choose MDY in the Date option list because that is the format of your date as it is at the moment.