Date to month converter in excel

[arpitraval]

I have exported table from Access. Where I do have option of Access dates, Dates by week, Dates by month. So i can see the month and data in between that month instead of going date by date.
But now i have exported that table in the excel and now i can not see the date by month. it is coming up with the dates instead of month. so it want allow me to put that filed in the column filed as it contains lots of data.
Kindly give me way how i can put the dates in the only month

for Example:

instead of 1/6/2001,2/6/2001,........1/31/2001 i want only January

 

[KenHigg]

I would suggest converting to a month in the access query before you export.

Would that work?

 

[Brianwarnock]

You can do it in excel but I'm inclined to agree with Ken.If you want to do it in Excel create a named array of the months ie Jan feb etc and then if your date is in A1 =INDEX(months,MONTH(A1)) will return the month.

Brian

 

[arpitraval]

Thanks for your reply guys. it has helped me.