Another way

="(" & TEXT(MID(A1,2,LEN(A1)-2),"00") & ")"

If this post helps click Yes
---------------
Jacob Skaria


"John" wrote:

I have a set of data in the form
(9)
(12)
(8)
(34)
(45)
I would like to search and append a '0' to single characters between brackets.

Searching on (?) finds the correct items but (0?) does not turn (9) into
(09). Can any one help?