I am not that computer-literate.

When I type in "=TEXT(TODAY(),"mmmm dd, yyyy")" in a cell of 97Excel xls,
it did convert into date.
It shows the same "=TEXT(TODAY(),"mmmm dd, yyyy")" function in the cell.
All templates from 97Excel did not work.

But when I type it in 2003 Excel sheet, it automatically convert into
November 28, 2007.

just type in the date as 11/26/07 and the do formatcellsnumbercustom
and use

I could not quite follow your instruction. I got stuck at "number".

Jorge,





"Peo Sjoblom" wrote in message
...
It's no difference, the date functions haven't changed. What happened when
you tried it on excel 97?
Regardless you don't need the text function or the date function to get a
date to display as

November 26, 2007


mmmm dd, yyyy


--


Regards,


Peo Sjoblom


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

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

The above format works perfect on 2003Excel (from 2003 Office Suite) but
did not work on 97Excel file (from 97Office Suite).
Although I am using 2003Excel, I still use some excel templates from 97
Excel.

I would very much appreciate it if you could post the date function for
97 Excel.

Thank you. Jorge





"Rick Rothstein (MVP - VB)" wrote in
message ...
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


"Jorge Cervantes" wrote in message
...
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
|
|