+ Reply to Thread
Results 1 to 2 of 2

Formatting a formula output in a cell that has text

  1. #1
    Registered User
    Join Date
    04-03-2020
    Location
    NYC
    MS-Off Ver
    365 Pro Plus
    Posts
    72

    Thumbs up Formatting a formula output in a cell that has text

    So in one cell I'm trying to have a combination of formula and text that would output something like this: Today's Date: 9/21/2020

    I've written the formula as: ="Today's Date: "&TODAY()

    With this though, I keep getting an output for the date in a number format and am not sure how to format the TODAY() formula to the Short Date format.

    Any help on this would be great. Thanks!
    Last edited by jk2391; 09-21-2020 at 09:28 AM. Reason: Figured it out

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,078

    Re: Formatting a formula output in a cell that has text

    How about
    ="Today's Date: "&TEXT(TODAY(),"m/d/yyyy")

+ 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. Replies: 1
    Last Post: 04-04-2019, 12:19 AM
  2. Need to change macro - output formatting and formula
    By fmcg in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-19-2017, 08:03 PM
  3. Req: Formatting the text output
    By dhous007 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-10-2015, 06:38 PM
  4. [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
  5. [SOLVED] Compare a text cell with a numeric cell and output a text string
    By ids in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-25-2014, 07:39 AM
  6. [SOLVED] Nested IF with the output displaying text along with text from another cell
    By madhatr in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-21-2013, 09:30 AM
  7. [SOLVED] Formatting number output to a text file
    By aeroman01 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-30-2012, 01:22 PM

Tags for this Thread

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