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?
|