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

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




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.


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


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....