Hi,

z3 = (Mid(z, (InStr(1, z, "(") + 1), Len(z) - (InStr(1, z, "(") + 1)))
creates a string, which is 1.96%

I want to value it so I changed the formula to

z3 = val((Mid(z, (InStr(1, z, "(") + 1), Len(z) - (InStr(1, z, "(") + 1))))
but it does not work

Any ideas?

Thanks,
David