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.
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.