Forum Discussion

Kerem_'s avatar
Kerem_
Copper Contributor
Nov 13, 2019

percentage symbol goes the wrong way

Hi

So I have this huge spreadsheet with Arabic text and some Hebrew (both are RTL languages) with many many tables and charts that are connected to them. In the cells of most of the tables, I see the % symbol in the right, where it should be, 15% for example, but in the pie charts' labels that are connected to those tables the % is on the left: %15 (i'm attaching two print screen maybe it will be more clear).

I tried to delete the labels completely and add them again and it looks fine for a moment but then, I saved the file, closed it and open it again and problem came back. The add more mysterious to the situation in bar charts\graph line ETC the percent labels look fine. 

Hope some one can help me solve this mystery...

Thanks

excel
pie chart

3 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Nov 13, 2019

    Kerem_ 

    Have no idea why it appears by default, but you may open labels format pane and for values add and apply custom number format

    0.00%

    instead of your current one %0.00

    • Kerem_'s avatar
      Kerem_
      Copper Contributor
      Nov 14, 2019

      Thanks SergeiBaklan 

      Tried it, but it still insist to put the symbol on the left. Actually when i use this pseudo custom format it change the category  number type to percentage again change the custom to percent I'm using excel for many many years, and never encounter this behavior.

       

Resources