dates in excel

[sokevin]

hi..

i have dates like

10 jan 2004
3 feb 2004
5 jan 2004



i want to trim the dates so that the data is


jan 2004
feb 2004
jan 2004

how do i go about doing this??

thank

 

[Domenic]

Hi,

You can custom format the cells:

Format > Cells > Numbers > Custom > mmm yyyy

Hope this helps!

 

[Dave Peterson]

If they're really dates, maybe just formatting them as:
mmm yyyy
would work.