How To Convert Numbers to Words in Excel / Microsoft Excel

In this article, we are going to teach you the easiest way regarding how to convert numbers to Words in Excel or better still how to turn a numeric value in a Microsoft Excel worksheet into words by the use of what is known as Spell Number function.

How To Convert Numbers to Words in Excel / Excel Made Easy

This article is primarily aimed at teaching my colleagues who are currently using Microsoft Excel to do their project work. As you already know that to convert Numbers to Words in Excel is not easy unless you make use of the right technique as you are going to see here.

Already you know very well that there are lots of things that you cannot do today without the use of Microsoft Excel worksheet, and one of the greatest problem that people faces is how to convert Numbers to Words in Microsoft Excel. But after reading this article, it will be a thing of the past for you.

How To Convert Numbers to Words in Excel

You have to follow the steps squally, though it is very easy to follow. The first method for converting a number to its written equivalent in Microsoft Excel is to use direct entry.

For example, if you want to write out 107.75 into one hundred and seven dollars, seventy five cents, you can do this by entering the following formula into a cell:

=SpellNumber(107.75)

Another simple method you could use to change numbers to text in Microsoft Excel is to use what we called Insert Function. To execute this task, select the cell of your choice, and then, click Insert Function on the Formulas ribbon.

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.

But in case you don’t want to use that, then you can make use of the alternative means. That is by the use of Concatenate function to apply this formula to specific cells, but note that 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”)

If the above tutorial about how to convert Numbers to Words in Excel was helpful to you, then use the comment box bellow to drop your experience so that other can learn from it.

Comments are closed.