How to Spell Number in Excel

With Ultimate Suite for Excel

With Ultimate Suite for Excel, you can easily convert numbers to words. In this quick manual, find out how to use the Spell Number utility.

Before you start

Spell Number works with only one cell at a time. The result spelled number will be inserted into the cell that was selected before running the tool, so first, you need to select an empty cell for the result and then start Spell Number.

Start Spell Number

  1. In an Excel sheet, stand on the cell in which you want the spelled number to appear:

    Select a cell for result.

  2. In the ribbon, go to the Ablebits Tools tab, find the Utilities group and click the Spell Number icon:
    Spell Number in the ribbon.

    If the Utilities group is collapsed, click on it and select Spell Number in the drop-down:
    Spell Number in Excel ribbon.

Select options and get number spelled

In the Spell Number pane, choose your options and click the Spell button:

Spell Number pane.

  1. Select the cell that contains the value you want to spell or click the Select range icon and then select the cell:
    Select the cell.
  2. In this drop-down list, you can select currency if you want it to be spelled along with numbers. If you do not need any currency spelled, pick None:
    Select currency or pick None.

  3. This option lets you select the text case in which the result will be spelled:
    Choose the text case.
  4. Also, you may select decimal options if you want them to be spelled too:
    Pick decimal options.
  5. Check this box if you want to include zero cents.
  6. Opt for this option if you want to insert the result as a formula so if the value in your selected cell changes the spelled result would change too. Besides, if you've got a column with numbers, you can simply drag down the formula to get them all spelled.

    Note. Please note, the formula will be custom user-defined, and if the workbook is opened on another machine without Ultimate Suite for Excel installed, the result may be lost.

    The function arguments are the following:
    Spell Number formula.

    LetterCase
    0 – "lower case"
    1 – "Sentence case"
    2 – "UPPER CASE"
    3 – "Title Case"

    DecimalFormat
    0 – "None"
    1 – "and 10 cents"
    2 – "point 10 cents"
    3 – "= 10 cents"
    4 – "and ten cents"
    5 – "point ten cents"

    As for Currency, the value that you selected is automatically put into the formula. However, if you need currency that is not in the list, you can manually enter any other value into the formula in the following format:

    =AblebitsSpellNumber(A1,"currency name in singular form,currency name in plural form;coin name in singular form,coin name in plural form",3,1,FALSE)

    For example, if you need Hungarian forint, the formula may look like this:

    =AblebitsSpellNumber(A1,"forint,forints;fillér,fillérs",3,1,FALSE)

    Add custom currency.

    forint and forints are for the currency name for singular and plural values; fillér and fillérs are for coins–singular and plural.

  7. Here is the preview pane, you can look at the result before clicking the Spell button.

As soon as you are done with all the options, click the Spell button to get the spelled numbers inserted:
Click Text Toolkit.