#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Pivot Table Grouping

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   Report Post  
Posted to microsoft.public.excel.misc
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



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Pivot Table Grouping

Hi,
I also meet the same problems. Have u resolved it?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table Grouping Mike Excel Worksheet Functions 1 August 10th 08 08:41 PM
pivot table and grouping cricket7 Excel Discussion (Misc queries) 4 July 30th 07 08:56 AM
Grouping with a pivot table ROland Excel Worksheet Functions 1 November 3rd 06 06:35 PM
Pivot table grouping Susan_GW Excel Worksheet Functions 6 September 18th 06 08:52 AM
Grouping in Pivot Table Minerva Excel Worksheet Functions 2 January 11th 06 10:30 AM


All times are GMT +1. The time now is 11:40 PM.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"