Number to date conversion
Results 1 to 3 of 3

Thread: Number to date conversion

  1. #1
    Board Regular
    Join Date
    Apr 2014
    Posts
    283
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Number to date conversion

    In A1 I have 43244 Software Application. I want it to be 24/05/18 Software Application.

    I thought combining TEXT and LEFT would work but it doesn't.

  2. #2
    Board Regular
    Join Date
    Jun 2005
    Location
    London
    Posts
    7,743
    Post Thanks / Like
    Mentioned
    7 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Number to date conversion

    =TEXT(LEFT(A1,5),"dd/mm/yy")&RIGHT(A1,LEN(A1)-5)
    Neil

  3. #3
    MrExcel MVP Rick Rothstein's Avatar
    Join Date
    Apr 2011
    Location
    New Jersey, USA
    Posts
    35,099
    Post Thanks / Like
    Mentioned
    92 Post(s)
    Tagged
    33 Thread(s)

    Default Re: Number to date conversion

    Here is another formula that will also work...

    =REPLACE(A1,1,5,TEXT(LEFT(A1,5),"dd/mm/yy"))
    Rick's "mini" blog... http://www.excelfox.com/forum/f22/
    .
    Want to post a small screen shot? See Part B here.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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