Turning numbers into letters with a twist at the end

[jboymeng]

Hello everyone!

This is my first post! and I already did some research but I couldn't find any formula or module that could completely solve this problem.

The numbers to letters was already solved, but the twist is really difficult..

I need the numbers in cell A1 to become coded letters in cell B1..

letters and their corresponding values as follows;

A	1
B	2
C	3
D	4
E	5
F	6
G	7
H	8
I	9
J	0

<tbody>
</tbody>

The twist

X – STANDS FOR THE TENTH PLACE ZERO ( .”0”0)
Y – STANDS FOR THE HUNDRETH PLACE ZERO (.0”0”|)
Z – STANDS FOR THE SAME NUMERICAL VALUE AS THE NUMBER BEFORE IT, GIVEN THAT IT IS NOT THE THIRD SAME NUMBER

E.G.

• 10.00 IS AJXY
• 15.00 IS AEXY
• 11.50 IS AZEY
• 55.50 IS EZEY
• 159.50 IS AEIEY
• 333.00 IS CZCXY
• 212.20 IS BABZY
• 1,068.00 IS AJFHXY

And BTW I am using MS Excel 2007

I hope you guys can help me..
Looking forward to hearing from you and thanks in advance!

 

[Rick Rothstein]

This post is for Rick Rothstein and István Hirsch.
Thank you both for your help. As a small tribute the modules used will be named after you guys. It is the only way I can thank you and remember the guys who helped me out at the same time.

I am honored.

 

[István Hirsch]

Thank you very much. Please do not hesitate to ask questions if you bump into any new problem related with "My" module.

 

[jboymeng]

Excuse me Mr. Rothstein,

How can I use your UDF in access?

 

[Rick Rothstein]

Excuse me Mr. Rothstein,

How can I use your UDF in access?

I do not use nor program in Access, so I cannot be sure, but since I use no Excel specific functionality in the code I posted in Message #9, I can see no reason why that code would not work correctly in any Microsoft Office product, Access included.

 

[jboymeng]

I do not use nor program in Access, so I cannot be sure, but since I use no Excel specific functionality in the code I posted in Message #9, I can see no reason why that code would not work correctly in any Microsoft Office product, Access included.

Thank you for the input

 

[LloydFinancials]

The 2 codes are slightly different. It may never be an issue, but for 10.06, Istvan has EOZR, Rick has EOXR. I am thinking it should be EOXR, but not sure.

 

[István Hirsch]

The 2 codes are slightly different. It may never be an issue, but for 10.06, Istvan has EOZR, Rick has EOXR. I am thinking it should be EOXR, but not sure.

See post #11.