How do I convert values in figures to words in EXCEL 2000?

[Guest]

eg.a. convert 2056 to Two Thousand Fifty Six or
b. convert 12345 to Twelve Thousand Three Hundred Forty Five

 

[VBA Noob]

try this link

http://www.meadinkent.co.uk/xlnumberstext.htm

 

[Bob Phillips]

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

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)