I am trying to format the following column in Microsoft Excel to add the percentage sign after the second decimal:
5.8394
3.2922
3.2
4.461
1
I highlight the column and choose Format cells > Percentage > Decimal places: 2 and get the following result:
583.94%
329.22%
320.00%
446.10%
100.00%
If I choose Decimal places: 0, I get the following:
584%
329%
320%
446%
100%
How to I get Excel to show the original numbers as percentages without changing the values?