How to convert numbers to text (e.g 10 = Ten)

[Guest]

I want to convert numbers to words in Microsoft excel e.g 10 = Ten where
suppose 10 is in A1 and Ten should come automatically in B1

 

[Niek Otten]

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


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I want to convert numbers to words in Microsoft excel e.g 10 = Ten where
| suppose 10 is in A1 and Ten should come automatically in B1

 

[Ponty'NPop]

Perhaps,

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

HTH,
--
Kevin James.
Tua'r Goleuni


|I want to convert numbers to words in Microsoft excel e.g 10 = Ten where
| suppose 10 is in A1 and Ten should come automatically in B1

 

[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 the "SPELLNUMBER" function, which can be used in your
spreadsheets, two methods to convert numbers to words and two cheque
writing routines.