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

C

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to convert the numerical to text (ie 1200 to One thousand two 1
Excel does not accept text format! 0
How to convert a numericaldigit to words?Thanks inadvance. 5
Found few bugs in my daily routine of work in excel for MAC 0
HOW DO I SET UP A DEMAND PLANNING EXCEL SPREADSHEET 1
Found few bugs in my daily routine of work in excel for MAC 0
How can I invert an Excel List, means colums become rows and vv.? 2
Converting URLs in comments to Markdown-formatted links 2

Top