Convert date into a specific format

[Panfergrrl18]

Hi All,

To make a formula work, I need to either change the date format in the pivot table (see tab "sheet1") or the raw data (see tab "data") - which is a formula. I need it to be in the format of "mmm-yy" - and no - going to the format cells menu doesn't work!!

Does anyone know of a formula that would work??

Thanks

example.xlsm

[FDibbins]

The formatting wont change the data in the PT because is it not a date, it is text that looks like a date = the same as the "date" in sheet2column A. To fix this, use this in A2, copied down...
=DATEVALUE(1&" "&D2&" "&B2)

Then refresh your table - you may need to redo that column in the PT

[shyamhappy]

=Text(A1, "MMM - YY" )

Even this might help you to get data in JAN - 12


__________________________________________________________________________________________________________________________________________
if you feel something has helped please click * to add to reputation

“I have not failed. I've just found 10,000 ways that won't work.”
― Thomas A. Edison

[Panfergrrl18]

Thank you. Appreciate the help