Excel date format yyyy mm dd

Convert date to yyyy-mm-dd format with formula 1. 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.

1. How do you write the date in YYYY MM DD format?

How do you write the date in YYYY MM DD format?

yyyy/M/d — Example: 2013/6/23. yyyy-MM-dd — Example: 2013-06-23.