Date format in PIVOT

[nischal4487]

Hi,

I have a sheet with column 'Created" and dates inserted to it in the format "1/8/2019 14:58 ". However, when I do a pivot , I want the created to be read as 'Jan' , Feb etc based on the dates without changing the date format in the data sheet. Is this possible, please help.

Regards,
Nik

 

[sandy666]

in PT:
group column Created by Month only
or
set for this column mmm format

 

[nischal4487]

I was such fool, it was simple.. thank you very much for helping out

 

[sandy666]

you are welcome, glad to help