View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default Pivot Table Grouping

Hi Carol

I think you will need to go to Control PanelRegional Settings and change
your Date format to UK

--
Regards
Roger Govier

"Carol Chan" wrote in message
...
I have created a Pivot table with the data grouping in month format, but
it
shown Chinese character (i.e. 1月) instead of english (i.e. Jan), how can I
change the format back into English format?

__________ Information from ESET Smart Security, version of virus
signature database 4828 (20100202) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 4828 (20100202) __________

The message was checked by ESET Smart Security.

http://www.eset.com