You are using an out of date browser. It may not display this or other websites correctly. You should upgrade or use an alternative browser.
excel 365
About this tag
This tag covers issues and questions related to Microsoft Excel 365, including troubleshooting problems like Excel opening blank documents when double-clicking files in Windows Explorer, and performing specific tasks such as converting date formats between DD-MM-YYYY and YYYY-MM-DD. Discussions focus on practical solutions for common Excel 365 usage scenarios.
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
Could someone please advise me on what to do about Excel 365 opening a document blank when directly clicking on the document in windows explorer. One has to first open Excel and then browse to the document for it to open correctly.
Sent from my iPhone using Windows Forums mobile app