This tip was printed from the Tips for Spreadsheets website at http://tipsforspreadsheets.com/.

Microsoft Excel 2003 Functions and Formulas - Convert Dollar Amounts to Words

Instead of displaying dollar amounts inside cells of a Microsoft Excel 2003 spreadsheet, ever needed to display their English equivalents instead?

Microsoft has developed a formula called SpellNumber that converts figures such as 22.70 into Twenty Two Dollars And Seventy Cents.

You can find the formula as well as instructions on Microsoft's website.



Press the "print" button on your browser or select "File" - "Print" to print this tip. Then, return to Microsoft Excel 2003 Functions and Formulas - Convert Dollar Amounts to Words.
 
Standard disclaimer applies - Read http://tipsforspreadsheets.com/copyright-disclaim.html.