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?
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):
Need more help with Excel? Check out our forum!
- How to convert number to words in excel in rupees without vba [solved] > Forum - Excel
- How to convert figure into words in excel
- How to convert date to general in excel
- Formula in Excel to turn numbers into text [solved] > Forum - Excel
- Converting number into words (Excel) [solved] > Forum - Word
- How to copy a Macro into a blank cell
- How many IF statements can you nest in Excel
- How to apply a function to multiple sheets on Excel
- How to perform a partial cell match in Excel?
- How to change author name in Excel: spreadsheet, VBA
- How to insert GIF in Excel: 365, sheet, VBA
- How to take screenshot in Excel: shortcut, sheet, cell
- How to enable VBA in Excel: Mac, Office 365
- Copy data from one excel sheet to another: automatically
- Change date format in Excel: to dd/mm/yyyy, mm/dd/yyyy
- Fix arrows keys in Excel: Scroll lock, alternative method