Set up a table off to the side or on another worksheet:
1 ONE
2 TWO
3 THREE
....

Now use vlookup to match the text to the digit.

Of course, this gets pretty nasty once you get above 9.






Niek Otten wrote:
http://xldynamic.com/source/xld.xlFAQ0004.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Akhil" wrote in message ...
|