Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Generate Text String
Is there a method for generating a text string for a number (e.g., 1234
generates "One thousand two hundred thirty four")? Thanks |
#2
|
|||
|
|||
There is no built-in way to do this. You need VBA or an addin, like Morefunc
from http://xcell05.free.fr/ HTH. Best wishes Harald "Joe S." skrev i melding ... Is there a method for generating a text string for a number (e.g., 1234 generates "One thousand two hundred thirty four")? Thanks |
#3
|
|||
|
|||
Joe
See Bob Phillips' site. http://www.xldynamic.com/source/xld.xlFAQ0004.html Gord Dibben Excel MVP On Wed, 2 Mar 2005 11:41:02 -0800, Joe S. wrote: Is there a method for generating a text string for a number (e.g., 1234 generates "One thousand two hundred thirty four")? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - counting cells containing a text string | Excel Worksheet Functions | |||
fixed column width with text string | Excel Discussion (Misc queries) | |||
Extract % from text string | Excel Worksheet Functions | |||
Formating a text string? | Excel Discussion (Misc queries) | |||
Newbie: How to search a text string from right | Excel Worksheet Functions |