Convert numbers to words in Excel: without VBA, formula

Convert numbers to words in Excel: without VBA, formula

This article will teach you how to convert a numeric value in a Microsoft Excel worksheet cell into words using what is called the Spell Number function.

How to convert numbers to words in Excel?

Without VBA

The first method for converting a number to its written equivalent is to use direct entry. For example, if you were looking to write out 47.75 into forty seven dollars and seventy five cents, you can do this by entering the following formula into a cell:

=SpellNumber(47.75)

Insert function

Another way to change numbers to text is to use Insert Function. To do this, select the cell that you want, and then, click Insert Function on the Formulas ribbon.

Under Or, select a category, followed by User Defined. In the Select a function list, select SpellNumber, followed by OK.

Next, enter the number or cell reference that you want, and then click OK.

Concatenate function

Alternatively, you can also use the Concatenate function to apply this formula to specific cells (though this method is a bit more complicated). To use this function, enter the code below (be sure to replace B6 with the applicable cell number):

=CONCATENATE(TEXT(UPPER(Spell Number(B6)),0),"ONLY")

Need more help with Excel? Check out our forum!

Subject Replies
How to calculate positions(1st,2nd,3rd...) in Excel 4
Unable to change date format in Excel 39
How to convert number into text in Excel 9
Convert number to spelling 28
Comparing two columns of names in Excel 8
Date formatting in dd/mm/yyyy 11
Automatically transfer data from one sheet to another 22
Removing " false" value in "IF" 10
Excel - To generate unique ID 4
converting number into words (Excel) 6

Excel