Forum Discussion
Excel percentage symbol without multiplication
Hello, My exported raw data table already contains percentages, which are currently formatted as numbers and do not contain a percentage symbol. If I now format these values as percentages they are ...
andrekuntze You could use a custom format like
0.0"%"
This will leave the number untouched but display it with the % symbol. For example, 50 will be displayed as 50.0%
Not convinced though if this is wise. To display a number like something that it is not could be confusing in case you need to perform calculations with it.