Converting Birth Date format

Discussion in 'Excel' started by Denise C., Jun 15, 2017.

  1. Denise C.

    Denise C.

    Joined:
    Jun 15, 2017
    Messages:
    1
    Likes Received:
    0
    How could I easily convert mm/dd/yyyy to yyyymmdd? I need all 8 characters though and my initial data can sometimes be such as m/d/yyyy so I'll need some type of filler. Any help will be GREATLY appreciated!
     
    Denise C., Jun 15, 2017
    #1
    1. Advertisements

  2. Denise C.

    Luck

    Joined:
    Dec 28, 2017
    Messages:
    8
    Likes Received:
    1
    Try TEXT(A2,"yyyymmdd")
     
    Luck, Dec 28, 2017
    #2
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.