Forum Discussion
Excel VBA Code Macro Not Showing in Developer Macros
I have Dollar amounts as $1000.00 in one column. Need the numbers converted into text for legal dovuments e.g. $1000.00 into text format One Thousand Dollars. I am using https://support.microsoft.com...
This UDF function which will appear in the function list, You need to type in a cell =SPELLNUMBER
this link might be helpful for you https://youtu.be/eMA39dU3UOE
or
Your macro setting might be disable which is not allowing to run the code.
Regards, Faraz Shaikh | Microsoft MVP, MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official/Best Answer & like it to help the other members find it more.
Getting error with code:
If DecimalPlace > 0 Then Cents = GetTens(Left(Mid(MyNumber, DecimalPlace + 1) & _ "00", 2))