Percentage in brackets became negative values

[billj]

Hi everyone,

I have a macro to make all values static as below. The trouble is if I run this macro, all text cells with values like (%33.3) will become -33.3%. I just want the text values remain the same. Is it possible to modify the code?

Please Login or Register  to view this content.

[PFDave]

Hi Billj,

Your calculation will return a negative number as you're dividing the small number by the large.

Try

Please Login or Register  to view this content.

in A2 then drag across and see if this solves your issue

Failing that I use the code

Please Login or Register  to view this content.

Could edit this for used range instead?

[shg]

Please Login or Register  to view this content.

[PFDave]

tidy shg! I'll borrow that too

[billj]

Many thanks, shg. It is a great code which does solve the problem.

[shg]

You're welcome.