Monday, July 6, 2020

Convert Numbers to Words in Excel


Convert numbers to words seems lot a often sought out request for Excel. One day it may be a function or even command that can be entered or clicked on the ribbon. However it's not, but there is a workaround solution that Microsoft has provided in the form of VBA. They actually posted a knowledge article (along with the code) on a function call SPELLNUMBER. Just do a web search for this text to find the Microsoft page to get the code and instructions on how to apply it. One caveat is that there will be some errors to troubleshoot through, but it wasn't so bad.

No comments:

Post a Comment