Month format not working

Is there an expert out this that can assist with this please.
I have attached a file wit the date in column 'A'

I want to convert this to mmm-yy in column 'B' so that it will produce a pivot as in the example

I have manually typed the date in column 'C' to demonstarte.
Month.xlsx
JagwarmanAsked:
Who is Participating?
 
Naresh PatelTraderCommented:
See attached use =TEXT(A2,"MMM-YY") & Formula Drop down.

Thanks
Month.xlsx
0
 
Saqib Husain, SyedEngineerCommented:
Use the formula

=value(A2)
0
 
NorieVBA ExpertCommented:
Select the data column, goto Data>Text to columns..., pick DMY as the column data format on step 3 and then click Finish.

Now you should have 'real' date values which you can group by year and month in the pivot table.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.