numbers
 

I need to know if I can type in a number (6) in a cell and either format the
sell to read (six) or write a formula that will read it in another cell????

-----Original Message-----
I need to know if I can type in a number (6) in a cell
and either format the
sell to read (six) or write a formula that will read it
in another cell????
.
use a lookup table like....

1 one
2 two
3 three

use vlookup function specifying exact matches only.

If numbers are more complex than 1, 2, 3 etc.

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


Gord Dibben Excel MVP

On Wed, 2 Mar 2005 06:55:48 -0800,
wrote:


-----Original Message-----
I need to know if I can type in a number (6) in a cell
and either format the
sell to read (six) or write a formula that will read it
in another cell????
.
use a lookup table like....

1 one
2 two
3 three

use vlookup function specifying exact matches only.