Excel percentage symbol without multiplication

[andrekuntze]

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?

[#2]

@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.