question on pivot table

  • Thread starter Thread starter Keyur
  • Start date Start date
K

Keyur

i have a column which states months. Before i had abbreviations for th
months and now i want them to be full names. when i changed them th
drop down list for the month field in the pivot table shows th
abbreviated names as well. is there any way to get rid of them withou
making a new pivot table.

thank
 
Hi

Remove the month field from the pivot table, then refresh
and then add the month field again.
Hopefully this helps.

regards
 
Back
Top