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 multiplied by 100. Is there a way to just append the percentage symbol without multiplying the values by 100?
1 Reply
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.
