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")
