Share via

SpellCurrency

Anonymous
2016-10-03T16:16:56+00:00

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.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-10-03T17:26:10+00:00

    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

    Was this answer helpful?

    3 people found this answer helpful.
    0 comments
  2. Anonymous
    2016-10-03T16:41:41+00:00

    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

    Was this answer helpful?

    0 comments
  3. Anonymous
    2016-10-03T16:23:55+00:00

    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

    Was this answer helpful?

    0 comments