How can I extract name of the month (MMMM) from the previous cell while using EXCEL 2003.
A AMIT Aug 18, 2006 #1 How can I extract name of the month (MMMM) from the previous cell while using EXCEL 2003.
N Niek Otten Aug 18, 2006 #2 =TEXT(A1,"mmmm") -- Kind regards, Niek Otten Microsoft MVP - Excel | 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 | How can I extract name of the month (MMMM) from the previous cell while using | EXCEL 2003.
G Gary''s Student Aug 18, 2006 #3 Use formatting: Format > Cells... > Number > Custom and then use mmmm
