View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Ragdyer
 
Posts: n/a
Default show character value of a month rather than numeric?

Just use
=TODAY()
And custom format the cell to
mmm
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"jim sturtz" wrote in message
...
the month function gives me 1 for the value of month(today()), can i get
january instead?

thanks.

jim

microsoft.public.excel.newusers