On Mon, 14 Nov 2005 13:33:46 GMT, "bramruis via OfficeKB.com" <u15176@uwe
wrote:

Ron,

This works great.
Thanks again for your help.


You're welcome. Glad it's working.


Bram.

Ron Rosenfeld wrote:
Just a matter of using the formatted result in my formula, rather than the
numeric amount; and also handling text representations of the last digit
instead of numeric representations.

In the formula below, you may want to change the format string "0.00" in the
TEXT function if you want the result displayed in some other format.

For example $1,234,567.01 will be converted to 1234567.0A.

If what you want is $1,234,567.0A, then change the format string to:

"$#,##0.00"

======================================
=LEFT(TEXT(A1,"0.00"),LEN(TEXT(A1,"0.00"))-1)&
IF(RIGHT(TEXT(A1,"0.00"),1)<"0",CHAR(RIGHT(
TEXT(A1,"0.00"),1)+64+9*(SIGN(A1)=-1)),
CHAR(123+2*(SIGN(A1)=-1)))
=======================================

Ron,

[quoted text clipped - 30 lines]

--ron

--ron

--ron