A few words of thanks would be greatly appreciated.

How To Convert Numbers to Words in Excel

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.

Convert Numbers to Words in Excel

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:


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.

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):


Image: © Dzmitry Kliapitski - Shutterstock.com

A few words of thanks would be greatly appreciated.

Ask a question
CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jeff Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.
This document, titled "How To Convert Numbers to Words in Excel," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (https://ccm.net/).