Month(a1) is a number. You cannot display it as text.

However, you can easily display just the month of the date. So, in your example,
use a custom format of mmm for A1.

If you want both the date, and the month, then for a2 use:

=a1, and format as mmm

--
Regards,
Fred


"steveK" wrote in message
oups.com...
Surely this is possible....

I'm creating a gantt chart to use at work and want row 12 to be month
and row 2 to be date

Jan Jan Jan
1 2 3
etc.

I'm able to derive months as numbers like this
A1 is 1/1/2001
A2 is =MONTH(A1)
However I can't then convert the result "1" into a text display
"January."

I've also tried Arrays
1 Jan
2 Feb
3 Mar
etc
Then using {=IF(array=array2, A2)} and various other permutations, but
nothing seems to work... thoughts? Thanks :o) steve