📎 AI Summary:
The thread discusses how to convert a date in Excel from the format DD-MM-YYYY to YYYY-MM-DD. The original poster asks for a way to automatically change the date format, while a respondent suggests that if the dates are recognized as proper date formats, simply changing the cell format would suffice. The original poster acknowledges this advice, expressing gratitude, indicating a helpful and constructive exchange.
Curious

Curious

Excellent Member
Member details
Joined
Mar 2, 2010
Messages
150
Thread Author #1
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
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.
Sort by date Sort by votes
Neemobeer

Neemobeer

Windows Forum Team
Staff member
Member details
Joined
Jul 4, 2015
Messages
8,995
#2
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.
 

Upvote 1 Downvote
Solution
Curious

Curious

Excellent Member
Member details
Joined
Mar 2, 2010
Messages
150
Thread Author #3
Neemobeer said:
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.
Click to expand...
Thanks guy.
 

Upvote 0 Downvote
You must log in or register to reply here.