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...
1. Your video goes too fast to follow steps. Wish it was slower to follow steps.
2. How to correct the following red color error (Bold Below)
DecimalPlace = InStr(MyNumber, ".")
' Convert cents and set MyNumber to dollar amount.
If DecimalPlace > 0 Then Cents = GetTens(Left(Mid(MyNumber, DecimalPlace + 1) & _ "00", 2))
MyNumber = Trim(Left(MyNumber, DecimalPlace - 1))
3. Macro setting is not diasbled.
Got Macro working. Getting following error
Result = Result & GetDigit _
Right(TensText, 1)) ' Retrieve ones place.
Result = Result & GetDigit _
Right(TensText, 1)) ' Retrieve ones place.