How to display 5 into May in mmm format?
=DATE(YEAR(NOW()),A1,1)
Format as "mmm"
--
HTH,
Laura Cook
Neenah, WI
"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
|