New answers tagged regex
1
Since your sheet's locale is United Kingdom you can try the following in a new column (change ranges per your needs)
=ArrayFormula(IF(B3:B="",,
IFERROR(REGEXREPLACE(B3:B,"\.","/")^1,B3:B)))
Now format this column as format > number > date.
If you need a more general formula use
=ArrayFormula(IF(B3:B="",,...
1
Your spreadsheet is in a locale that currently uses the dd/mm/yyyy data format. The data has apparently been imported while the spreadsheet was set to a locale with another date format, which has caused the data to not get converted but stored as text strings instead.
When your csv data is in a date format that differs from that of the spreadsheet, it will ...
Top 50 recent answers are included
