Thread: date conversion
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ranvin56 ranvin56 is offline
external usenet poster
 
Posts: 5
Default date conversion

I have a spreadsheet that once you input a date in one of the cells it
separates it in two other cells one for the month and one for the day.
However, in doing so it list the month by numbers (ex "10" for "Oct"). I want
to have the month inputed by its name. I've tried "If" statement but there's
too many levels in the function for it to work. Does anyone have any
suggestions?