Adding a percentage sign to a number field in Excel

Question

We have an Excel document with a Percentage column. This column can be sorted from large to small and vice versa because it contains numbers. The percentage indicator that should follow the number is the only item that is lacking.

What we have is this:

It would be great if it could show the following and still be able to sort from small to big:

114,87 %
50 %
81 %
91 %

Whatever I try in the formatting option Custom, I always end up with trailing zeros or changed values.

Answer 1

Format these cells with custom format ?\%