Formula to convert number to alphabet

[choy96]

looking for a formula that can be convert the number to the alpha .
example A=1 , B=2, C=3, D=4, E=5...
when i key in 34.21 , it will show CD.BD

thks in advance

[JBeaucaire]

There is not a built in formula or function in Excel that does this, but we can create one and add it to your workbook.

Please Login or Register  to view this content.

How to install the User Defined Function:

1. Open up your workbook
2. Get into VB Editor (Press Alt+F11)
3. Insert a new module (Insert > Module)
4. Copy and Paste in your code (given above)
5. Get out of VBA (Press Alt+Q)
6. Save as a macro-enabled workbook


If you were to type 34.21 in cell A2, then this formula in B2 would now give you your desired results:

=NumbersToLetters(A2)

[choy96]

ALREADY PASTE THE AS ABOVE INTO VBA AND SAVE AS MACRO-ENABLE. results become #NAME? WHY ?

[JBeaucaire]

You didn't post a workbook for me to check your work. I'd guess you didn't follow the instructions exactly and posted the code in the wrong kind of module. But I'm only guessing.

[choy96]

EXAMPLE-ENABLE.xlsm

this is the attachment.

[sktneer]

You need to follow these steps to make the UDF suggested by JBeaucaire work correctly.
Open your workbook --> Press Alt+F11 to open VBA editor --> On the VBA editor window --> Insert --> Module --> Paste the code given in post#2 in the code window --> Close the VBA editor --> Save your workbook as Excel Macro-Enabled Workbook --> Done.

Now you can use it like this.....

Please Login or Register  to view this content.

[choy96]

Done ... Thks. My problem is although i have save as macro enable , it aslo need to press on menu "yes" to enable macro.

[choy96]

how to add the . to convert it become X ?
example example A=1 , B=2, C=3, D=4, E=5...
when i key in 34.21 , it will show CDXBD

[sktneer]

Try this.....

Please Login or Register  to view this content.