Convert Numbers to words for Excel 365 for Mac

[ruumi]

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-69442c...

Also if someone can direct me to a chart on how to use Windows shortcuts on Mac keyboard. For example this article says use Alt 11 and Alt Q for Windows, but it didn't work on Mac.

Thanks for help.

[#2]

The syntax error is in this line
Cents = GetTens(Left(Mid(MyNumber, DecimalPlace + 1) & _ "00", 2))

[#3]

@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.

https://support.microsoft.com/en-us/office/keyboard-shortcuts-in-excel-1798d9d5-842a-42b8-9c99-9b721... 

[#4]

@Riny_van_Eekelen can you please help me with the errors you deleted?

[#5]

@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.

[#6]

Dear excel community group.. i have one addins for excel number to text function ie.. spellnumber...and im added in adins folder and followed all steps but itsw not working my office professional 2021