+ Reply to Thread
Results 1 to 5 of 5

TODAY() function to text

  1. #1
    Forum Contributor
    Join Date
    11-23-2007
    Location
    Suffolk, UK
    Posts
    298

    TODAY() function to text

    Hello,

    I need to find a way to take the TODAY() function and and split the individual digits out and recombine them to a text cell, i have tried using the MID function but it returns the serial rather than the actual number, e.g

    today() 02/01/2009 needs to be shown as 020108 (this needs to be text rather than a number) as it is included within an INDIRECT formula.

    any ideas
    thanks reg
    Last edited by reggie1000; 01-02-2009 at 10:31 AM.

  2. #2
    Cheeky Forum Moderator Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Convert TODAY() results to text

    Try this:

    Please Login or Register  to view this content.
    Does that help?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  3. #3
    Valued Forum Contributor Richard Schollar's Avatar
    Join Date
    05-23-2006
    Location
    Hampshire UK
    MS-Off Ver
    Excel 2002
    Posts
    1,264
    Quote Originally Posted by Ron Coderre View Post
    Try this:

    Please Login or Register  to view this content.
    Does that help?
    I reckon it would if it was:

    =TEXT(TODAY(),"ddmmyy")



    Richard

    Note that I am assuming the OP made a small error in his original post requesting that 02/01/09 be returned as 020108
    Richard Schollar
    Microsoft MVP - Excel

  4. #4
    Cheeky Forum Moderator Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Convert TODAY() results to text

    DOH! You're right, of course....Thanks for catching that.

  5. #5
    Forum Contributor
    Join Date
    11-23-2007
    Location
    Suffolk, UK
    Posts
    298
    Thanks guys,

    works a treat

    cheers reg

+ 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