Date Conversion Issue

[dbwiz]

Please see following portion of an export in Column A that is supposed to be in Date format. If you right click on the cell and choose format it says it is in Date format mm/dd/yyyy but if you do text to columns it appears that it is General format. I need it to look like July - 2011 and am really frustrated because I have tried everything I know and then some. Your guruship is most appreciated!

Excel Workbook
	A
1	PEDate
2	07/31/2011
3	07/31/2011
4	07/31/2011
5	08/31/2011
6	07/31/2011
7	07/31/2011
8	07/31/2011
9	08/31/2011
10	07/31/2011
11	07/31/2011*Closing Entry Adjustments
12	07/31/2011*Closing Entry Adjustments
13	08/31/2011
14	07/31/2011
15	07/31/2011*Closing Entry Adjustments
16	07/31/2011*Closing Entry Adjustments
Sheet1

Excel 2007

 

[Joe4]

It looks like you will need to do a Text To Columns, choosing the asterisk ("*") as your delimiter and choosing the "Date" option (and the MDY format) for the format of your date field.

Then, just change the format of the column to a Custom Format of
"mmmm-yyyy" to get it to appear like "July-2011".