how do i covert number to words in excel?

P Vasanth Kumar · 08-23-2006, 12:25 AM

One cell have the value is 100 in a number , But I want to that cover t in
words Like One Hundred, Like this I want to convert numbers to words. Please
help me. I am waiting for ur reply.

**raypayette** · 08-23-2006, 07:25 AM

Here it is:
http://www.ozgrid.com/VBA/ValueToWords.htm

**daddylonglegs** · 08-23-2006, 07:31 AM

You could try downloading Morefunc add-in from here

http://xcell05.free.fr/

Amongst other useful function is the NBTEXT function which should do what you want

**shahulnrt** · 01-27-2014, 06:15 AM

unable to view your link http://xcell05.free.fr/..
Please do need full.

**shahulnrt** · 01-27-2014, 06:13 AM

Greetings!!!

Required formula for converting Number to Words( For Salary - 15000 to fifteen thousand only)

**arlu1201** · 01-27-2014, 07:56 AM

shahulnrt,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.