'How to disable default % applying behaviour in Excel?
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?
Solution 1:[1]
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.
Solution 2:[2]
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
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Prema |
| Solution 2 |