MrExcel Publishing
Your One Stop for Excel Tips & Solutions

how to convert


Posted by amroo on August 01, 2001 2:15 AM

Bonjour everybody,
I want the number of the month in A1 converted in text
in B1.
Thanks for the help
Amroo


Posted by Aladin Akyurek on August 01, 2001 2:31 AM

I reckon you want the name of the month in B1. If so, use in B1

=VLOOKUP(MONTH(A1),{1,"January";2,"February";3,"March";4,"April";5,"May";6,"June";7,"July";8,"August";9,"September";10,"October";11,"November";12,"December"},2,0)

or

=CHOOSE(MONTH(A1),"January","February","March","April","May","June","July","August","September","October","November","December")

Pick one that you like.

Note. If A1 contains a number between 1 and 12 instead of a date, replace MONTH(A1) with just A1.

Aladin

Posted by Mark W. on August 01, 2001 7:28 AM

=TEXT((A1&"/1")+0,"mmmm")

Posted by Mark W. on August 01, 2001 7:32 AM

My reading of Amroo's posting is that A1 contains
and integer -- not a date value; however, if it
did contain a date value one could simply use
the TEXT function as follows....

=TEXT(A1,"mmmm")