Values to text (2003, SP1)

Topic

New Reply

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”?

Reply | Quote

Replies

Try this:

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

Reply | Quote

Thanks, Hans. That worked.

Reply | Quote

Thanks, Hans. That worked.

Reply | Quote

Try this:

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

Reply | Quote