Whenever I insert % symbol at the end of a string in a cell it will automatically convert to percent format, i.e. the value is divided by 100. I want to disable the auto convert to % type and only string is allowed. How will I do that?

CodePudding user response：

Difficult. The only way I could prevent the percentage calculation was by inserting an other charakter first. Not all where working. Blank Space is not working. ' is not working.

But these are working, but they are invisible, which can make problems.

CodePudding user response：

Quote the cell with an apostrophe: '100%. This will force the type of a cell to string, which means the percent sign is part of the cell.

Or use a custom number format: 0%. In this case the percent sign is not part of the cell. You even do not have to type it.

In most cases the last approach is better, because you can still calculate with the cell. But when you export the table, you will loose the percent sign. In this case the first alternative may be better.

Example: https://docs.google.com/spreadsheets/d/17LnWQztuV9JvMt1A-pVsWGjkLIP6XL0ytJRCkoWzPjc/edit?usp=sharing