How to Convert Number to Words in Excel?Initially, Microsoft Excel was developed to process large data arrays. However, it also created accounting records like invoices, evaluations, or balance sheets quickly and effectively. In more or fewer payment documents, it is necessary to duplicate numeric values with their word form. Excel doesn't have a default function that displays numbers as English words in a worksheet. Still, you can add this capability by pasting the following SpellNumber function code into a VBA (Visual Basic for Applications) module. This function lets you convert dollar and cent amount to words with a formula. For example, 25.50 would read as Twenty Five Dollars and Fifty Cents. This can be very useful if you're using Excel as a template to print checks. So what you need is not just convert numbers to words in Excel (123.45 to one hundred and twenty three, forty five), but spell out dollars and cents ($29.95 to twenty nine dollars and ninety nine cents), pounds and pence for GBP, Euros, and Eurocents for EUR, etc. If you want to convert numeric values to text format without displaying them as words, use the TEXT function as an alternative. Even Excel 2016 doesn't have a built-in tool for spelling numbers, not to mention earlier versions. But that is when Excel is really good. You can always improve its functionality using formulas in all their combinations, VBA macros, or third-party add-ins. If you are looking for the number to text conversion, which means you want Excel to see your number as text, it's a bit different. Usually, you need to change the cell format in Excel, do the following things:
How to Convert Numbers to Words Using SpellNumber VBA MacroMicrosoft didn't want to add a tool for the number to words conversion. But they created and published the special VBA macro on their website. You can find the macro mentioned as "spellnumber formula". However, it is not a formula but a macro function or an Excel User-defined function (UDF). The SpellNumber option can write dollars and cents. If you need a different currency, you can change "dollar" and "cent" with your choice. Below you will find a VBA code and follow the following steps, such as: Step 1: Open the workbook where you need to spell the numbers into words. Step 2: Press Alt + F11 to open the Visual Basic Editor window. If you have several books opened, check that the needed workbook is active using the list of projects in the upper left corner of the editor, or one of the workbook elements is highlighted with blue. Step 3: In the editor menu, go to the Insert tab and click on the Module button. Step 4: You will see a window named Module1. Please select all of the code in the frame below and paste it to this window. Step 5: Press Ctrl + S to save the updated worksheet. You will need to resave your workbook. When you try to save the workbook with a macro, you'll get the message, "The following features cannot be saved in macro-free workbook". Step 6: A VB project dialog box appears. Click on the No button. Step 7: You can save your file as an Excel Macro-Enabled Workbook (.xlsm) to keep your file in its current format.
Step 8: And click on the Save button to save the file. Disadvantages of Using Macro to SpellNumber in Excel
Next TopicHow to Make a Table in Excel |