How to convert Numbers into text
 

How to convert Number into Text e.g.

If i enter 10,000 in one cell then Ten Thousand appear in another cell. wat
will be the formula for it?

http://support.microsoft.com/default...b;en-us;213360

S. Majid Hussain wrote:
How to convert Number into Text e.g.

If i enter 10,000 in one cell then Ten Thousand appear in another cell. wat
will be the formula for it?

This file might be a help:
http://www.bygsoftware.com/examples/...s/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.

The code is open and commented.


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

"S. Majid Hussain" <S. Majid wrote in
message ...
How to convert Number into Text e.g.

If i enter 10,000 in one cell then Ten Thousand appear in another cell.
wat
will be the formula for it?

How to convert Numbers into text
 

"Rowan" wrote:

http://support.microsoft.com/default...b;en-us;213360

S. Majid Hussain wrote:
How to convert Number into Text e.g.

If i enter 10,000 in one cell then Ten Thousand appear in another cell. wat
will be the formula for it?