How can I extract name of the LONG MONTH from previous cell.

How can I extract name of the month (MMMM) from the previous cell while using
EXCEL 2003.

=TEXT(A1,"mmmm")

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"AMIT" <[email protected]> wrote in message news:[email protected]...
| How can I extract name of the month (MMMM) from the previous cell while using
| EXCEL 2003.

Use formatting:

Format > Cells... > Number > Custom and then use mmmm
--
Gary's Student


"AMIT" wrote:

> How can I extract name of the month (MMMM) from the previous cell while using
> EXCEL 2003.