changing data to text?

Thanks for the help with the save_as macro guys!

I enter a date as 1/7/02, which is displayed at January 7,2002. When the macro pulls the date out, if gets 1/7/02, which of course, can't be used as a directory(don't want it like that, I just need January. I tried making a custom cell that would just display the month from the other cell's entire date, but it will pull the entire data as 1/7/02.

Thanks for any help!