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:
Whatever I try in the formatting option Custom, I always end up with trailing zeros or changed values.