Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
I also meet the same problems. Have u resolved it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot Table Grouping | Excel Worksheet Functions | |||
pivot table and grouping | Excel Discussion (Misc queries) | |||
Grouping with a pivot table | Excel Worksheet Functions | |||
Pivot table grouping | Excel Worksheet Functions | |||
Grouping in Pivot Table | Excel Worksheet Functions |