Results 1 to 5 of 5

Thread: changing the date format

  1. #1

    changing the date format



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi Gurus,

    I'm currently struggling with the following problem:

    I have a date in the following format: 25-JAN-2013
    I want to convert this to: 20130125

    Could anyone help me with a solution?

    Many thanks!

    Emile

  2. #2
    Create this custom format using (CTRL+1) to enter formatting submenu
    Format is yyyymmdd ;apply to required cells

    HTH

  3. #3
    Quote Originally Posted by Enigma View Post
    Create this custom format using (CTRL+1) to enter formatting submenu
    Format is yyyymmdd ;apply to required cells

    HTH
    Hi,

    I already tried this option, it returns yyyy0125..

  4. #4
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,820
    Articles
    0
    Excel Version
    O365
    What is your Excel language Emile?

  5. #5
    Quote Originally Posted by Bob Phillips View Post
    What is your Excel language Emile?
    Just found out that this is indeed the problem. It had to be jjjj0125 since this PC is in Dutch. Never work on this pc so didn't noticed at first.

    Thanks!!

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •