Remedy system exports dates in Date and Time format (8/1/2009 12:19:59 PM) I want to convert this into a Month-Year format for a pivot table. I tried reformatting the column to Mon-YY and then Copy > Paste Special > Values. But it doesn't work. I can't seem to get rid of the date/time. I even tried =LEFT to try to strip the time out. But then it just gives me Excel numeric code.
Anyone have any ideas for a formula that will turn "8/1/2009 12:19:59 PM" into Aug-09?
Anyone have any ideas for a formula that will turn "8/1/2009 12:19:59 PM" into Aug-09?