Date formatting doesn't seem to be working.
Take a look at line 3509. You will notice the difference with the date. Excel doesnt read the format as a date if you would try to filter the column.
Date formatting doesn't seem to be working.
Take a look at line 3509. You will notice the difference with the date. Excel doesnt read the format as a date if you would try to filter the column.
b3509 =and drag down![]()
=Right(Left(A3509,5),2)&"-"&Left(A3509,2)&"-"&Right(A3509,4)
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks