How to Convert Number to Words in Excel – javatpoint

next →
← prev

How to Convert Number to Words in Excel?

initially, Microsoft Excel was developed to process boastfully data arrays. however, it besides created accountancy records like invoices, evaluations, or counterweight sheets quickly and effectively .
In more or fewer requital documents, it is necessity to duplicate numeric values with their discussion shape. Excel does n’t have a nonpayment officiate that displays numbers as english words in a worksheet. still, you can add this capability by pasting the follow SpellNumber function code into a VBA ( Visual Basic for Applications ) module. This function lets you convert dollar and cent amount to words with a recipe .
For exercise, 25.50 would read as Twenty Five Dollars and Fifty Cents. This can be identical utilitarian if you ‘re using Excel as a template to print checks. sol 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 penny for GBP, Euros, and Eurocents for EUR, etc .
If you want to convert numeral values to text format without displaying them as words, use the TEXT function as an option.

even Excel 2016 does n’t have a built-in cock for spelling numbers, not to mention earlier versions. But that is when Excel is in truth good. You can always improve its functionality using formulas in all their combinations, VBA macro, or third-party add-ins .
How to Convert Number to Words in Excel
If you are looking for the numeral to text conversion, which means you want excel to see your total as text, it ‘s a bit different. normally, you need to change the cell format in Excel, do the pursuit things :

  • Select your range with numbers.
  • Press Ctrl+1on the Number tab and select “Text” in the Category

How to Convert Numbers to Words Using SpellNumber VBA Macro

Microsoft did n’t want to add a instrument for the numeral to words conversion. But they created and published the special VBA macro on their web site .
You can find the macro mentioned as “ spellnumber formula “. however, it is not a formula but a macro officiate 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 respective books opened, check that the needed workbook is active using the list of projects in the upper left corner of the editor program, or one of the workbook elements is highlighted with blue .
Step 3: In the editor menu, go to the Insert check and click on the Module button .
How to Convert Number to Words in Excel
Step 4: You will see a window named Module1. Please select all of the code in the human body below and paste it to this window .

Step 5: Press Ctrl + S to save the update 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 “ .
How to Convert Number to Words in Excel
Step 6: A VB project dialogue 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 stream format .

  • Click on the File tab.
  • Select the Save As option.
  • Click the Save as typedrop-down menu.
  • And in the save as type field, choose the “Excel macro-enabled workbook” file type.

How to Convert Number to Words in Excel
Step 8: And click on the Save button to save the file .

Disadvantages of Using Macro to SpellNumber in Excel

  • First, you must know VBA to modify the code according to your needs. It is necessary to paste the code for each workbook where you plan to change it. Otherwise, you will need to create a template file with macros and configure Excel to load this file at each start.
  • The main disadvantage of using a macro is if you send the workbook to somebody else, this person will not see the text unless the macro is built into the workbook. And even if it’s built-in, they will get an alert that there are macros in the workbook.

adjacent subjectHow to Make a Table in Excel

← prev
next →

informant : https://alltopus.com
Category : Lastest

Related Posts

Leave a Reply

Your email address will not be published.