What do you mean by "the above function did not work"?

What error message did you get? If not an error message, what value did the
formula =TEXT(DATE(2007,11,25),"mmmm dd, yyyy") return? If the cell merely
displayed the formula, rather than the result, make sure that you haven't
got the cell formatted as text; if it is, then format as General, and
either re-insert the formula, or hit F2 to get into formula edit mode and
hit Enter.
--
David Biddulph

"Jorge Cervantes" wrote in message
...

OK.
Now I realized that there was a confusion somewhere.
Since my wife computer is installed with 97office suite, I checked how
those functions work on 97Excel.

With native 97Excel or 2003Excel files, "=TEXT(DATE(2007,11,25),"mmmm dd,
yyyy")" function worked just fine.
No problem.

But the above function did not work on any of 97Excel files which are
opened under 2003Excel.

(Note: my computer is installed with 2003 Office Suite. But I use
97Excel templates under 2003 Excel.).

I hope that this clarifies what was the problem.

Jorge











"Peo Sjoblom" wrote in message
...
While he might be replying back to Rick he quotes JMB so he might have
thought that JMB was Rich? Nevertheless there is no need for any
functions and also if he wants to use the TEXT function

=TEXT("11/26,07","mmmm dd, yyyy")


will suffice.



--


Regards,


Peo Sjoblom


"Sandy Mann" wrote in message
...
Hi Peo,

Being as Jorge was replying to Rick and the only post from Rick that I
can see in this thread is:

*****************************************
Is this what you are looking for?

For today: =TEXT(TODAY(),"mmmm dd, yyyy")

Specified date: =TEXT(DATE(2007,11,25),"mmmm dd, yyyy")

Rick
*********************************************

I am wondering if my OE is missing posts again becuase that formula
works in XL97

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Peo Sjoblom" wrote in message
...
It's not a function and it works in Excel 97


--


Regards,


Peo Sjoblom


"Jorge Cervantes" wrote in message
...
Rick,

Could you please come up with a similar function for 97Excel?
I am waiting. Jorge




"JMB" wrote in message
...
Change the cell format
Format/Cells/Custom
mmmm d, yyyy


"Jorge Cervantes" wrote:

You are correct though, but that is not what I asked for.
When I tried both functions, it shows 11/26/07.

I need a date function for "November 26, 2007".

Jorge




"Niek Otten" wrote in message
...
=today()

Or, on any other day:

=DATE(2007,11,25)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Jorge Cervantes" wrote in message
...
| What is the date function for November 25th, 2007 for Excel?
TIA.
| Jorge
|
|