Spelling out Numbers in Excel

One of the more common requests that I receive is how to spell out a number in words. In the past, I always sent people of to buy either JWalk's Power Utility Pack or Bob Flanagan's Spreadsheet Assistant.

There is a new knowledgebase article at Microsoft that offers code for a SpellNumber function. If you are comfortable with copying VBA code into a project, you can now get a free function to convert $217.65 to "Two hundred seventeen dollars and sixty five cents".

The code is at http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q213360.

If you are not familiar with entering VBA macros, see this page: http://www.mrexcel.com/tip038.shtml for an article about how to take code from the web and insert it in your project.