Curious

Extraordinary Member
Joined
Mar 2, 2010
Messages
123
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
 


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


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


Back
Top