I have a vlookup formula doing a different calculation depending of the value
in a drop down list. The format of the result of the calculation shall be
either a number or a percentage depending on the value of the same drop down
list. I see two options, either a macro that runs automatically when I change
the drop down list and that updates the format of my cells or a formula that
converts the format from number to percentage.
How do I run a macro based on a change in a drop down list?
Is there any formula to convert the format from number to percentage?

Thanks a lot!