Thread: date conversion
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default date conversion

hi
how are you spliting the date?

regards
FSt1

"ranvin56" wrote:

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?