|| 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|
|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.
|Get this information as a document
accompanied by Excel worksheets
|Click here for details about
file. It has been rewritten for Excel 2010.
|file: xlNumbersText.htm||© meadinkent.co.uk 2014||Page last updated Feb14||CMIDX S3 P5 Y|