Pivot Table Grouping

[Carol Chan]

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?

 

[Roger Govier]

Hi Carol

I think you will need to go to Control Panel>Regional Settings and change
your Date format to UK

--
Regards
Roger Govier

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