Adding a '%' after each value automatically

Question

I'm not a huge fan of formatting cells as a percent in Excel because it automatically multiplies the value by 100.

I want to write my own VBA function that looks for a change in value in a particular cell and adds a '%' to the end of it.

How can I write some code to look for changes automatically?

Answer 1

Change the format string to 0\%.
The \ escapes the percent character and prevents Excel from multiplying it by 100.