| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
nembers to text
Can somebody help me regarding number to text convertion in excel
eg. "1234" to "One thousand two hundred thiry four" |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
nembers to text
See this site
http://www.xldynamic.com/source/xld.xlFAQ0004.html -- Regards Ron de Bruin http://www.rondebruin.nl wrote in message oups.com... Can somebody help me regarding number to text convertion in excel eg. "1234" to "One thousand two hundred thiry four" |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
nembers to text
This file might be a help:
http://www.bygsoftware.com/examples/...s/num2wrds.zip It's in the "Accountants" section on page: http://www.bygsoftware.com/examples/examples.htm It contains the "SPELLNUMBER" function, which can be used in your spreadsheets, two methods to convert numbers to words and two cheque writing routines. The code is open and commented. -- Andy Wiggins FCCA www.BygSoftware.com Excel, Access and VBA Consultancy - wrote in message oups.com... Can somebody help me regarding number to text convertion in excel eg. "1234" to "One thousand two hundred thiry four" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using TEXT and &TEXT - display numbers with commas, underline text | Excel Discussion (Misc queries) | |||
| separate alpabets & nembers | Excel Worksheet Functions | |||
| Max of % nembers in column WITHOUT counting dates | Excel Worksheet Functions | |||
| How do I remove the repested numbers in list of nembers in Excel? | Excel Discussion (Misc queries) | |||
| extracting text from within a cell - 'text to rows@ equivalent of 'text to columns' | Excel Programming | |||
Linear Mode
