Text of integer

[Bob Mc]

I could not find a way to do this. Is it possible to have the actual text
displayed for an integer.....for example, in a cell there is "8" (without
the quotes) and based on that, I'd like to have displayed in another cell
"eight" (without the quotes).

Thanks,
Bob Mc

 

[Don Guillett]

You could try the archives for number to text and get LOTS of hits.

 

[J.E. McGimpsey]

In case you don't know where the archives are:

http://google.com/advanced_group_search?q=group:*excel*

 

[Bob Mc]

Thanks. That was going to be my next question

Bob Mc