View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Laura Cook Laura Cook is offline
external usenet poster
 
Posts: 10
Default 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