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

[Niek Otten]

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|

 

[chris.cudmore]

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.