Hi Michele
You can use this function
=TEXT(A1,"mmm")
--
Regards Ron de Bruin
http://www.rondebruin.nl
"Michele" wrote in message ...
I have a wooksheet that you enter the date in one column(07-05-04), then the
vendor in the next column, discription in the next, who's file is is under,
blank column, then price. What I want to do is when i type the date
(07-05-04) it will automaticlly write the month (July) in the empty column.
So if i type (08-02-04) in the next row, it will automaticlly add the word
August in the cell speciified. Is this possible.
Thanks for you help