Dear All,
Currently I am creating a report from data coming from our SharePoint server.
What Im trying to do is to create a timeline that shows mutations per set time of date.
The only issue that I'm having, is that the date formats are different in the same column. Some dates are shown as d/mm/yyyy while some are d/mm/yy.
Changing the format by going to "format cells" does not seem to work for the dates that are shown as d/mm/yyyy.
Is there any possible way to change all date formats to the same? I'm really not looking forward to manually locate and changing the date formats in a sheet that has over 250k rows..
Please let me know if possible, that would be amazing!
Bookmarks