Excel 2007 - 10/14/2011 23:59 PM

I'm having a tough time converting a date/time (MMDDYYYY HHMM PM) to a regular date MMDDYYYY only.