It happened to me in different files that when I paste a column of percentage values, they appear with the symbol ’ as first digit, for example:
If I do mathematical operations on such a value, there is no problem, but if I use the percentage as a range of values for, say, bar graphs, no bar shows unless I remove the ’ symbol from the percentage cell(s).
PS: I adjusted the graphs y-axis length so that the values would be visible (the y-axis is max 5%).
What is that symbol? Why is it pasted together with a percentage value? How can I have it removed/ignored (automatically) for graphs?
Thank you for your hints.