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?

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?

date conversion
 

=TEXT(A1,"mmm")

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"ranvin56" wrote in message ...
|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?