Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    San Jose, California, USA
    Posts
    290
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Values to text (2003, SP1)

    OK, I know I used to know how to do this, but I must be getting old. I have a cell (N2) formatted as a date which contains the value 11/30/04.. I want to use that value in another cell which contains a text string and the date value spelled out as "November 30, 2004". I have the formula "="Financial Statements for the period ended "&MONTH(N2)&"/"&DAY(N2)&"/"&YEAR(N2)" which works but, obviously, shows the date as "11/30/04". What is the format command I need to make it display "November 30, 2004"?

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

    Re: Values to text (2003, SP1)

    Try this:

    ="Financial Statements for the period ended "&TEXT(N2,"mmmm d, yyyy")

  3. #3
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    San Jose, California, USA
    Posts
    290
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Values to text (2003, SP1)

    Thanks, Hans. That worked.

Posting Permissions

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