Formatting a whole number column as a percentage adds two zeroes

[jdubs]

I have a whole number column that I want to display as a percentage. When I change the Formatting type to percentage it adds 2 zeroes and 2 decimal places e.g. 80 --> 8000.00%, 113 --> 11300.00%, etc.

It doesn't seem like you can reduce the decimal places below zero so this is very strange behavior. 

[v-angzheng-msft]

 Hi, @jdubs 

According to your description, you only need to reformat the target column to get the desired result.

Result:

Is this the result you want? Hope this is useful to you

Please feel free to let me know If you have further questions

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AllisonKennedy · Accepted solution]

if you want 10% your value needs to be stored as 0.1. You could use the Transform > Standard > Divide in Power Query to convert the whole number to decimal, then format as percent

[jdubs]

That's perfect Allison. Thank you!