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, <[email protected]>
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.