How to display 5 into May in mmm format?
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
|