New answers tagged

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