+ Reply to Thread
Results 1 to 4 of 4

Pickup of Date from Numbers

  1. #1
    Forum Contributor
    Join Date
    07-21-2009
    Location
    Kuwait
    MS-Off Ver
    Excel 2016
    Posts
    253

    Smile Pickup of Date from Numbers

    Hello, All

    Hope all is fine, i am back from vacation..

    I have a quick question..I am getting some numbers in a report like "288050345".

    the first digit "2" is code, and the next 6 digits "880503" is "yy-mm-dd"..

    I want a formula to arrange them as "dd/mm/yy" as date not numbers..

    How it will be possible..

    Thanks for any help in advance..
    Last edited by tariqnaz2005; 10-27-2011 at 03:04 AM.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    32,545

    Re: Pickup of Date from Numbers

    HTML Code: 
    288050345		03/05/1988
    		=DATE(MID(A2,2,2),MID(A2,4,2),MID(A2,6,2))

    Regards
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Contributor
    Join Date
    07-21-2009
    Location
    Kuwait
    MS-Off Ver
    Excel 2016
    Posts
    253

    Re: Pickup of Date from Numbers

    Wow, TMShucks

    Thanks a lot for quick reply efforts..

    God Bless you..

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    32,545

    Re: Pickup of Date from Numbers

    You're welcome.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1