Can i convert numbers into string format?

[talia_k]

Is there a way in Execl (2002) to convert numbers into string format? For
Example 1234 to "One thousand two hundred thirty four".

 

[Guest]

Hi
This is one of the features included in the free ASAP Untilities' add-in.
There are loads of other useful functions included as well. Their address is
www.asap-utilities.com

 

[Andy Wiggins]

This file might be a help:
http://www.bygsoftware.com/examples/zipfiles/num2wrds.zip

It's in the "Accountants" section on page:
http://www.bygsoftware.com/examples/examples.htm
It contains two methods to convert numbers to words and two cheque writing
routines.

The code is open and commented.




--
Regards
-
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy

 

[Bob Phillips]

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

--

HTH

RP
(remove nothere from the email address if mailing direct)