numbers

[Guest]

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????

 

[Guest]

-----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.

 

[Gord Dibben]

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

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


Gord Dibben Excel MVP