Forum Discussion
Convert Numbers to words for Excel 365 for Mac
Hi I have tried this link to use for this purpose. However there is a error when I execute it. https://support.microsoft.com/en-us/office/convert-numbers-into-words-a0d166fb-e1ea-4090-95c8-69442cd5...
ruumi Copying and pasting from the web included some unwanted characters. Deleted them and the code seems to do what is described in the article.
With regard to Alt-shortcuts in Excel for the Mac, they simply don't exist to the same extent and are quite different. Easiest to refer you to a MS support page. Link below.
Riny_van_Eekelen can you please help me with the errors you deleted?
ruumi There are two lines of code that have an underscore "_" in them. One is the line you mentioned, where you can just delete the space underscore directly after the &-sign.
The other one is a bit further down.
Result = Result & GetDigit _
(Right(TensText, 1)) ' Retrieve ones place.
Just get rid of the underscore and put the entire code on one row, like so:
Result = Result & GetDigit (Right(TensText, 1)) ' Retrieve ones place.
Then it works for me.