Good day everyone!
I would like to ask your help with a code that turns a set of numbers in to a set of letters. For example 123.00=ABCXY but the thing is the code can change from 1234567890=ABCDEFGHIJ to 1234567890=POIUYTREWQ and with decimals being XY, X is for the tenths and Y is for the hundreths also the change depending on the code.
I have asked this same question in the "Excel questions" part of the Forum and was given a solution by 2 good gentlemen (Mr.István Hirsch and Mr.Rick Rothstein) and now I am moving from Excel to Access. I have tried to copy and paste the code but I don't really understand how it works hehe.
For more details please refer to the following post:
http://www.mrexcel.com/forum/excel-questions/821937-turning-numbers-into-letters-twist-end.html
Whether you can help or not, thank you for taking the time to read this.
Have a great day ahead.
I would like to ask your help with a code that turns a set of numbers in to a set of letters. For example 123.00=ABCXY but the thing is the code can change from 1234567890=ABCDEFGHIJ to 1234567890=POIUYTREWQ and with decimals being XY, X is for the tenths and Y is for the hundreths also the change depending on the code.
I have asked this same question in the "Excel questions" part of the Forum and was given a solution by 2 good gentlemen (Mr.István Hirsch and Mr.Rick Rothstein) and now I am moving from Excel to Access. I have tried to copy and paste the code but I don't really understand how it works hehe.
For more details please refer to the following post:
http://www.mrexcel.com/forum/excel-questions/821937-turning-numbers-into-letters-twist-end.html
Whether you can help or not, thank you for taking the time to read this.
Have a great day ahead.
Last edited:
