Share via

Excel Pivot Table Display Dates in Part English and Part in Chinese after changing to Proplus (English version)

Anonymous
2016-11-17T15:18:49+00:00

Hi, i am getting crazy after changing the Proplus in Eng (Version). The pivot table's time intelligence shows the dates in part English and Chinese for all my working files.  I couldn't get rid of the Chinese characters by formatting.

I have also change the language settings with Excel into Eng. Yet, notthing happen to undo the changes. Please kinldy offer help.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2016-11-17T20:02:22+00:00

    Hi Anthony,

    Based on your description, please try the steps below:

    1. Go to Control Panel > Clock, Language, and Region > Region and Language. Check whether your Format is English.

    1. You can change the format by right clicking the cell, click Format Cells, in Locale dropdown menu, select the location you want then choose the Type.

    If the issue persists, please share the screenshot of your Excel version and the example file with us via Private Message.

    To check your Excel version, please go to File > Account.

    Regards,

    Tisky

    3 people found this answer helpful.
    0 comments
Answer accepted by question author
  1. Anonymous
    2016-11-19T00:10:59+00:00

    Hi Anthony,

    Have you tried steps above? Could you share some updates with us?

    Regards,

    Tisky

    1 person found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-11-19T08:04:04+00:00

    Tisky

    I thought i replied to your message already.

    Yes, it work fine now. The dates got back to normal. They are all displayed in English

    Just that i cannot understand, why I need to change the settings on both the control panel and that of the Excel

    Thank you for your help anyway

    Regards

    Anthony

    0 comments