can we convert number to text in excel as if 1= One
 

can we convert number to text in excel as if 1= One
 

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Akhil" wrote in message ...
|

can we convert number to text in excel as if 1= One
 

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