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.
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.