Results 1 to 3 of 3

Thread: Change date value format

  1. #1

    Change date value format

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

    HI All,

    Can anyone help me to develop one macro which change the date in dd-mon-yyyy format to yyyy/mm/dd format.

    If partial date are there, then it should be filled with hyphen symbol (_) e.g. for 2010 , output will be 2010/--/--
    for May-1998 , output will be 1998/05/--

    I am able to do this conversion through excel formula(see column B) from some forum but can not populate the whole data properly.

    That means for cell (1,1,) containing two value, output populated for one value (excluding days).
    Similarly for cell(9,1), cell(11,1), cell(12,1)---> output is displayed as blank (see in col B)

    Can I get my exact requirement just like for column "REQUIREMENT (Is it possible)"

    Thanks in advance for your help
    Attached Files Attached Files

  2. #2
    can anyone help me whether it is possible or not

  3. #3
    Conjurer snb's Avatar
    Join Date
    May 2013
    Excel Version
    start splitting those string in seperate cells, that contain only 1 date per cell (use texttocolumns).

Posting Permissions

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