If I had a spreadsheet with numerical values down one column, integers
between 1 and 9. I want to be able to "reverse" each number so that 1
will become 9, 2 becomes 8, 3 becomes 7, etc, down to 9 becoming 1.

It's so that I can analyse a survey where people have been asked to
give a 1 for their first choice, 2 for their second choice etc.
Sometimes they have 6 choices, sometimes 9, sometimes 5 depending on
the question. Blanks not filled in get zero. I'm allocating 9 points
to the 1st choice, 8 points to the second choice etc, then adding them
up. Maximum points is the most popular.

Is there a formula you can think of that would do the reversing
automatically? Or something in the Paste Special that would work?

Steve Wylie
United Kingdom