Windows 11 EXCEL 365

Curious

Extraordinary Member
A question:
I have a cell in excel with date format DD-MM-YYYY.
This cell has a date for example 19-4-2023.
I have another cell with the format YYYY-MM-DD
How can I automatically convert the date 19-4-2023 to 2023-4-19?
Thanks
José Paiva
 
If the cells are all in a date format (not just generic text) and in the same column or row you should be able to just select the entire row/column and change the date format to the one you desire.
 
Back
Top