Good Morning! I pulleddata from an Oracle data base and I am trying to convert a date that is in a text format to a date. I have done this before but have no totally forgot.

Example. Cell A1 is 5/9/2012 10:31. I want B1 to = May-2012

Thanks in advance