Hi guys, What can I do if I have many dates in database but a few of them were format like a text. I change format to date. But when I click on filter they are not sort to years. I tried to select column and changed format but nothing.date.PNG
Hi guys, What can I do if I have many dates in database but a few of them were format like a text. I change format to date. But when I click on filter they are not sort to years. I tried to select column and changed format but nothing.date.PNG
Hi,
Use a helper column with following and then replace the result:
=SUBSTITUTE(A1,".","/")+0
or use text to column wizard.
Regards,
Khalid
Select the cells
DATA>text to columns>delimited>next>next>select date>under date select DMY >finish
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
thanks +rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks