Home

How do I change the date format in Excel when the date is stored as 06.07.2018?

change date format in excel

Asked on May 11, 2020 in Computer.
Add Comment
Cancel
    • 1 Answer(s)

    If the cell is already formatted as date:

    1. Select the cell(s)
    2. Press Ctrl+1
    3. Go to Number Tab
    4. Select Date in category list
    5. Select the format you want

    If the cell is not formatted as date, but as text of general:

    Say the date 06.07.2018 is in cell A1. In cell B1, write the following formula

    =DATE(RIGHT(A1,4),MID(A1,4,2),LEFT(A1,2))

    Cancel
    Answered on May 11, 2020.
    Add Comment
    Cancel

    • Your Answer

    By posting your answer, you agree to the privacy policy and terms of service.