Tag Info

New answers tagged


Perhaps you are requesting an array formula: =arrayformula(A1:A&", "&B1:B)


OP wants UK-style dates (dd-mm-yyyy) and has formatted accordingly. However this is in a sheet with the Locale set to where dates are normally presented as mm-dd-yyyy. An entry of 18-4-2014 is not recognised as valid US-style so is left as text (see comment rather than OP) – date formatting is not applied. An entry of 5-2-2014 is recognised as a valid ...


The solution is to set the correct Local under the Spreadsheet's settings ("This affects formatting defaults, such as currency."). So if you want US.locale style (MM-DD-YYYY), then choose US.Locale. If you are in a different locale and want formatting

Top 50 recent answers are included