View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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