Results 1 to 6 of 6
  1. #1
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Simple Date Question! (Excel 2000>)

    Hi,
    It bugs me that I can't figure out the answer, as I know this should be simple, but please help with this question!

    1. In a1 of attachment, how do I format the date to read a date in the concatenated text?
    Must read: Report printed on 30 March 2005.
    Regards,
    Rudi

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Simple Date Question! (Excel 2000>)

    <pre>="The report was printed on " & TEXT(TODAY(),"d mmmm yyyy")</pre>


    Steve

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Simple Date Question! (Excel 2000>)

    Possibility 1: include the format in the formula:

    ="The report was printed on " & TEXT(TODAY(),"d mmmm yyyy")

    Possibility 2: reduce the formula to =TODAY() and set a custom number format in Format | Cells...:

    "The report was printed on "d mmmm yyyy

    The literal text must be enclosed in quotes.

  4. #4
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Simple Date Question! (Excel 2000>)

    Perfect.
    Thanx a stack guys!
    Regards,
    Rudi

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Simple Date Question! (Excel 2000>)

    Your second option will require the column to be very wide to avoid the ##### display. It will not extend past the column as it is not text but a displayed number...

    Steve

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Simple Date Question! (Excel 2000>)

    That's true. You could use "Center across selection", but the formula with TEXT is more flexible.

Posting Permissions

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