Hi Biff

Interestingly this also works with just
=(A1="","",TEXT(A1*29,"mmm"))

--
Regards

Roger Govier


"T. Valko" wrote in message
...
If you want this to be a TEXT value:

=IF(A1="","",TEXT(DATE(2006,1,A1*29),"mmm"))

Biff

"Eric" wrote in message
...
Does anyone know how to display 5 into May in mmm format for excel?
If I input the number 5 in cell A1, then I would like to see May in
cell B1.
Does anyone have any suggestion?
Thank you for any suggestion
Eric