Forum Discussion
Date Formatting
Hi
Please Could anyone help me changing a date from the format Nov 16, 2018 to the format 16/11/2018. Right clicking on the cell and using format cells doesn't work as there is no option for this.
It looks like your dates are in text format, you can't covert them to dates just by applying date format. You may convert them to dates in helper column by formula like
=(MID(A1,5,2) & "-" & LEFT(A1,3) & "-" & RIGHT(A1,4))+0
and after that apply desired date format to it.
It looks like your dates are in text format, you can't covert them to dates just by applying date format. You may convert them to dates in helper column by formula like
=(MID(A1,5,2) & "-" & LEFT(A1,3) & "-" & RIGHT(A1,4))+0
and after that apply desired date format to it.
Thank you so much works perfectly :)
You are welcome
