Forum Discussion
Date format
Hi......Can someone help I have a excel with 6k entries and the date is in American......YYYY-MM-DD I tried to format the cell to English DD-MM-YYYY. i highlighted and selected Columns to te...
MarieSpence Use Text-to-Columns on the Data ribbon. In step 3, select "Date:" and "YMD" and Finish. This will convert the dates to a format that matches your local settings.
By the way, YYYY-MM-DD is the ISO date format. In the US, they use MM-DD-YYYY. If that is what you intended to write, choose MDY in step 3, as described above.