Convert Numbers to words for Excel 365 for Mac

%3CLINGO-SUB%20id%3D%22lingo-sub-2583927%22%20slang%3D%22en-US%22%3EConvert%20Numbers%20to%20words%20for%20Excel%20365%20for%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2583927%22%20slang%3D%22en-US%22%3E%3CP%3E%3CEM%3EHi%3C%2FEM%3E%3C%2FP%3E%3CP%3E%3CEM%3EI%20have%20tried%20this%20link%20to%20use%20for%20this%20purpose.%20However%20there%20is%20a%20error%20when%20I%20execute%20it.%3C%2FEM%3E%3C%2FP%3E%3CP%3E%3CEM%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fconvert-numbers-into-words-a0d166fb-e1ea-4090-95c8-69442cd55d98%3FWT.mc_id%3D365AdminCSH_Smc%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fconvert-numbers-into-words-a0d166fb-e1ea-4090-95c8-69442cd55d98%3FWT.mc_id%3D365AdminCSH_Smc%3C%2FA%3E%3C%2FEM%3E%3C%2FP%3E%3CP%3E%3CEM%3EAlso%20if%20someone%20can%20direct%20me%20to%20a%20chart%20on%20how%20to%20use%20Windows%20shortcuts%20on%20Mac%20keyboard.%20For%20example%20this%20article%20says%20use%20Alt%2011%20and%20Alt%20Q%20for%26nbsp%3B%3C%2FEM%3E%3CI%3EWindows%2C%20but%20it%26nbsp%3Bdidn't%20work%20on%20Mac.%3C%2FI%3E%3C%2FP%3E%3CP%3E%3CEM%3EThanks%20for%20help.%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2583927%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2584252%22%20slang%3D%22en-US%22%3ERe%3A%20Convert%20Numbers%20to%20words%20for%20Excel%20365%20for%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2584252%22%20slang%3D%22en-US%22%3EThe%20syntax%20error%20is%20in%20this%20line%3CBR%20%2F%3ECents%20%3D%20GetTens(Left(Mid(MyNumber%2C%20DecimalPlace%20%2B%201)%20%26amp%3B%20_%20%2200%22%2C%202))%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
New Contributor

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.

 

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

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

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