+ Reply to Thread
Results 1 to 6 of 6

Convert output of =today() into the text value of it in another cell USING MACRO

  1. #1
    Registered User
    Join Date
    09-24-2014
    Location
    Auckland, New zealand
    MS-Off Ver
    2013
    Posts
    50

    Convert output of =today() into the text value of it in another cell USING MACRO

    Hi there,

    I know how to do this using copy, paste special, values only... but I would like to automate it if possible as it is going to come up a lot.

    Any help much appreciated.

    Regards
    Chris

  2. #2
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Convert output of =today() into the text value of it in another cell USING MACRO

    Date is the VBA equivalent of = TODAY()
    Format is similar to =TEXT(...)

    Please Login or Register  to view this content.
    Above result in:
    24/03/2017 (default for dates in my Excel setup)
    24 03 2017
    Fri Mar 2017
    Friday March 2017

    Please Login or Register  to view this content.
    places B2 value in required format in C2
    Last edited by kev_; 03-24-2017 at 03:21 AM.
    Click *Add Reputation to thank those who helped you. Ask if anything is not clear

  3. #3
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Convert output of =today() into the text value of it in another cell USING MACRO

    or if you want the equivalent of copy and paste values with the format maintained:
    Please Login or Register  to view this content.
    which copies from the active cell and pastes into the cell in the next column

    as does this:
    Please Login or Register  to view this content.
    Last edited by kev_; 03-24-2017 at 03:33 AM.

  4. #4
    Registered User
    Join Date
    09-24-2014
    Location
    Auckland, New zealand
    MS-Off Ver
    2013
    Posts
    50

    Re: Convert output of =today() into the text value of it in another cell USING MACRO

    Thank you Kev.

    I'm not sure how to implement those two pieces of code. I know where to find the script editor but I think there must be some brackets or other characters missing. I guess you probably expect I would know how to do that but i am not that familiar with coding. I tried placing it in various ways but it didn't work. What am I missing?

    Regards

  5. #5
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Convert output of =today() into the text value of it in another cell USING MACRO

    Hi Chris

    File containing the macros is attached to get you started
    Select cell B3 and then {CTRL} t to copy B3 and paste values and format to C3

    To get to the VBA area: {ALT} {F11}

    Do you have the Developer Tab activated?
    If not see here
    Attached Files Attached Files
    Last edited by kev_; 03-24-2017 at 10:59 AM.

  6. #6
    Registered User
    Join Date
    09-24-2014
    Location
    Auckland, New zealand
    MS-Off Ver
    2013
    Posts
    50

    Re: Convert output of =today() into the text value of it in another cell USING MACRO

    Thank you Kev, I'll have a look at this tonight.

    Chris

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro code for today's date + text copied to specific cell
    By ash3angel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-24-2015, 09:35 AM
  2. [SOLVED] Cell reference, output dates to numeric. Should output as text
    By lifeseeker1019 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-02-2015, 05:51 PM
  3. Macro to automatically convert prt scr image-based text to real text in cell
    By jasonfromchico in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-24-2014, 02:27 PM
  4. Convert text mm-dd-yy date from external file & compare to TODAY()
    By Frontier in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-02-2014, 01:43 PM
  5. MACRO help - convert cell text to hyperlink
    By excelmonster in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-18-2012, 05:19 AM
  6. [SOLVED] Convert Today()+3 to text
    By phish3rz in forum Excel General
    Replies: 6
    Last Post: 12-10-2012, 12:19 PM
  7. Convert TODAY() Value To Text
    By Sam Steiner in forum Excel General
    Replies: 3
    Last Post: 05-16-2007, 02:20 PM

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