How to convert digits into text

's Computer Specifications

Eg. 10 should be converted as "Ten"

's Computer Specifications

Bob Phillips shows two ways of doing this on his site:

http://www.xldynamic.com/source/xld.xlFAQ0004.html

Hope this helps.

Pete

On Aug 19, 7:06*am, Naseem <Nas...@discussions.microsoft.com> wrote:
> Eg. *10 * should be converted as *"Ten"

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
I would like to convert digits (eg. 16) to text SIXTEEN in Excel	=?Utf-8?B?TmF2ZWVuIEcu?=	Microsoft Excel Worksheet Functions	1	9th Jul 2006 04:33 PM
How can I convert digits to alpha text?	=?Utf-8?B?UmljaGFyZCBTZWx6ZXI=?=	Microsoft Excel Misc	1	8th Feb 2005 06:36 PM
Convert 8 digits to leading alpha plus 6 digits following?	Lee Jeffery	Microsoft Excel New Users	1	21st Sep 2004 04:25 AM
Convert Numbers (Digits) to Text.	=?Utf-8?B?UHJhdmVlbiBCaGF0?=	Microsoft Excel Worksheet Functions	4	19th May 2004 07:36 AM
freeware to convert text to binary digits	Dos-Man	Freeware	1	3rd Feb 2004 08:31 PM