| Date ........ | Aging Date |
|08.01.2019|
|10.01.2019|
|11.01.2019|
|12.01.2019|
|13.01.2019|
|14.01.2019|
|15.01.2019|
|16.01.2019|
My problem is, I want to convert from text format to Date dd-mmm-yyyy , 08-Jan-2019, for entire column.
how I need to do to make it like this,
| Date..... ..... | Aging Date |
|08-jan-2019|
|10-jan-2019|
|11-jan-2019|
|12-jan-2019|
|13-jan-2019|
As for me, I do it like this,
- Code: Select all
sheet.Columns(30).EntireColumn.Style.NumberFormat = "dd-MMM-yyyy"
but unfortunately, it doesnt work. I mean, it doesnt format it to entire column, and doesnt change the date from 08-01-2019 to 08-Jan-2019.
Please someone do help me, and thanks in advance.