How to change date format in excel from DD/MM/YYYY to YYYY-MM-DD?

Faisal Memon 21 Reputation points
2022-02-14T13:59:50.703+00:00

I am trying to change date format from DD/MM/YYYY to YYYY-MM-DD. I tried =text formula, which did not worked, I tried changing the format of the cell by going to Custom and manualy typing the format, it didn't worked either and I also tried =right formula which did not helped me also. Can someone help me to get the date format changed from DD/MM/YYYY to YYYY-MM-DD in Microsoft Excel 2013

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,641 questions
0 comments
Accepted answer
  1. Ceasar Chen_MSFT 4,391 Reputation points
    2022-02-15T05:35:22.07+00:00

    Hi, @Faisal Memon
    According to your description, your date may be in text format.
    It is recommended to use the DATEVALUE function to convert the date to an Excel serial number first, and then customize the cell format to YYYY-MM-DD
    Here is an example screenshot:
    174323-image.png
    174324-image.png
    174351-image.png

    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Faisal Memon 21 Reputation points
    2022-02-15T10:41:15.267+00:00

    Hi @Ceasar Chen_MSFT . I found a solution for the above problem I was facing. Upon checking I found that there was a space entered before the date due to which the format of that cell was not changing to any format with all the steps we were using. I removed that additional space and then changed the format and it accepted the format from Format Cells box itself easily. Hope this will also help you.