Thanks Dave and Ron.
Your formulas both work great!!

Bram.

Ron Rosenfeld wrote:
Yes, sorry. You're right.
Here are the values that I need:
[quoted text clipped - 33 lines]

--ron

Well, have to make zero a special case, then.

You can use this formula:

=LEFT(A1,LEN(A1)-1)&IF(MOD(A1,10)<0,CHAR(
RIGHT(A1,1)+64+9*(A1<0)),CHAR(123+2*(A1<0)))

--ron


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200511/1