David,

For the benefit of others, it would be a nice gesture to post your solution
as opposed to posting "Got it."

"David" wrote in message
...
Got it.

Thanks

"David" wrote:

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