SpellCurrency

Question

I have searched prior help responses for this topic, but I don't see any support for Excel 2016.

I would like to use the prior (versions 2013 and prior) 'SpellCurrency' formula in Excel 2016, but it does not appear to be supported. I am looking to have a field that spells currency found in a neighboring cell: i.e. $68,000 in a cell, spelled as 'Sixty-Eight Thousand Dollars' in the cell with the formula.

Answer 1

I have Excel 2016 and I just tried "SpellNumber" and it works fine

Please enter Excel > then Press "Alt+F11" > Under "Project - VBAProject" in upper left hand You'll see your workbook name > in blank area press right click > "Insert" > "Module"

Now you have clean white screen copy the VBA code from link above then past it there

and now close VBA Editor (there is no saving button) and Try Typing "=SpellNumber()" and refer to the cell that have number you want to spell it in it

* Then save your excel file as "Macro-Enabled" From Save as from File Menu

• Ahmad

Answer 2

Ahmad,

It looks like the 'Module' is accessible via 'View Code' on the 'Developer' tab within Excel 2016. Additionally, please note that the article you referenced is for much earlier versions of excel and does not appear to be applicable for Excel 2016.

If anyone has an updated formula to accomplish the before mentioned task within Excel 2016, it would be appreciated.

• James

Answer 3

Here an interesting VBA Code in link below will help you and  you will know how to install it into EXCEL   

https://support.microsoft.com/en-us/kb/213360

--

Regards,

Ahmad