Windows 11 How to Convert Date Format in Excel 365 from DD-MM-YYYY to YYYY-MM-DD

[Curious]

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

 

[Neemobeer]

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.

 

[Curious]

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.

Thanks guy.