| Feedback | Differences between Dates | Link chart titles to cell contents | |
Excel does not contain a built in function that will display a number as a series of words (i.e. a text string) but a search in Google will uncover several user defined functions to perform this task. They can each produce slightly different results and may be suitable for different purposes.
A user defined function called WordNum(value) will accept almost any number value and convert it into a long string of words in written English. The following examples show the results that can be obtained from the function. The value can be any number up to 999,999,999.
20001.0017 | Twenty thousand and One point Zero Zero One Seven |
2067202.0900 | Two million Sixty Seven thousand Two hundred and Two point Zero Nine |
78.0000 | Seventy Eight |
665.9800 | Six hundred and Sixty Five point Nine Eight |
-489.0000 | Four hundred and Eighty Nine |
105521.0000 | One hundred and Five thousand Five hundred and Twenty One |
The WordNum() function requires the following code to be copied and pasted in a Visual Basic module. Once the code has been added to a workbook, the Paste Function option should contain a new User Defined function called WordNum(). It is available to convert any values or cells containing a value into words.
Option Explicit
|
![]() |
Get this information as a document accompanied by Excel worksheets |
![]() |
Click here for details about
obtaining this file. It has been rewritten for Excel 2010. |
file: xlNumbersText.htm | © meadinkent.co.uk 2014 | Page last updated Feb14 | CMIDX S3 P5 Y |