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!
Excel
- How to convert number to words in excel
- Number to words in excel
- Convert number to words in excel
- How to convert Date to word in excel [solved] > Forum - Excel
- How to convert tamil font word file to pdf > Forum - Word
- How to convert pdf to word in tamil [solved] > Forum - Word
- How to open a PRN file in Office/Word 2010 [solved] > Forum - Word
- Tamil fond to pdf fond > Forum - Word
- Change date format in Excel: to dd/mm/yyyy, mm/dd/yyyy
- Copy data from one excel sheet to another: automatically
- How to take screenshot in Excel: shortcut, sheet, cell
- Fix arrows keys in Excel: Scroll lock, alternative method
- How to apply a function to multiple sheets on Excel
- How to change author name in Excel: spreadsheet, VBA
- How many IF statements can you nest in Excel
- How to display multiple columns in a validation list
- How to use Excel color cell if formula
- Check if a value exists in an array VBA
- How to enable VBA in Excel: Mac, Office 365
- How to use an IF statement to add 1 to total
- How to perform a partial cell match in Excel?
- VBA select case like: operator, string, statement
- Search and find using VBA in Excel
- How to run macro when data entered in a cell
- What is the VBA code to select last sheet in workbook
- How to insert file path in excel: cell, sheet
- How to insert GIF in Excel: 365, sheet, VBA
- How to disable auto recover in Excel
- Open and convert an Excel file in Notepad
- VBA Excel color codes: index number, list
- How to count names in Excel: formula, using COUNTIF
- How to enter multiple lines in a single Excel cell
- How combine IF function, SEARCH and ISERROR in Excel
- Run macro on opening: worksheet, workbook
- Create new sheet based on cell value: Excel, macro
- Recalculate Excel workbook before saving
- How to manipulate data in Excel: VBA
- Repeat rows in Excel: based on cell value, VBA
- Insert a hyperlink in Excel: with text, to another tab
- Most useful Excel formulas: for data analysis
- How to automatically transfer data between sheets in Excel
- How to change a column to numeric in Excel?
- How to transfer data from one Excel sheet to another?
- Recover Excel file: previous version
- Select the default number of processors in Excel
- How to add a number of days to a date in Excel
- How to copy a Macro into a blank cell
- How to apply if function in Excel: with dates, with text
- Mark sheet grade formula in Excel: template
- How to fill multiple Excel sheets from master sheet
- Insert picture in Excel: cell, shortcut, using formula
- Excel functions in French
- How to generate email notifications for Excel updates
- How to add sheet to workbook: VBA, Excel
- How to create a cascading combo box: Excel, VBA
- How to calculate VAT in Excel: formula
- Excel send value to another cell
- How to create calculator in Excel VBA
- Select empty cell in Excel: VBA
- Unlock password protected Excel file: Macro
- Excel export data: from one sheet to another
- How to connect VB 6.0 with MS Access
- Split a workbook into individual files in Excel
- How to create UserForm: in Excel, VBA
- Using VBA to find last non empty row: in column, in table
- Excel VBA add command button programatically
- How to remove leading apostrophe in Excel
- Compare two Excel sheets: and combine data
- How to change enter key function in Excel
- How to use Excel auto numbering formula
- Copy data from one Excel workbook to another
- How to change Excel date format
- How to insert a transparent image into an Excel document
- How to copy data to another workbook: using VBA
- How to count occurrences of characters and numbers in Excel
- Transfer Excel data from one sheet to another: VBA
- How to show or hide formula bar in Excel: VBA, shortcut
- Delete duplicates in Excel: column, formula
- How to insert blank rows using macros in Excel
- Conditional formatting with dates: in Excel
- Send email with attachment Excel: VBA, macros
- Auto generate serial number in Excel: VBA, formula
- Transfer a worksheet to another Excel workbook: without VBA
- Insert an image into an Excel comment box
- How to change row color in Excel VBA based on value
- Create a new workbook and copy data in Excel via a Macro
- Shortcuts to insert in Excel
- Run Macros in Excel: online, shortcuts, VBA
- How to clear formatting in Excel
- How to create a timer in Excel VBA
- How to create a drop-down list in Excel
- Excel IF, AND, OR, and NOT functions
- Update dates in Excel spreadsheet: each year, formula
- How to use conditional formatting in Excel
- Credit summation formula
- How to split text in columns in Excel
- How to copy data to multiple worksheets in Excel
- How to insert multiple rows in Excel with a macro?