Question: how to change date format from yyyy/mm/dd to dd/mm/yyyy?
Answer: Convert date to yyyy-mm-dd format with formula Select a blank cell next to your date, for instance. I1, and type this formula =TEXT(G1, "yyyy-mm-dd"), and press Enter key, then drag AutoFill handle over the cells needed this formula. Now all dates are converted to texts and shown as yyyy-mm-dd format.