In Excel, I want to put any value of figure in word. e.g. as in cheque there is figure in numeric as well as in word i.e. "Rs 45010/-" where is Rs is currency symbole in India this is in word will be "Rupees fourtyfive thousand ten ". I want convert the numeric figure in word in other cell .[/

I'm not entirely sure about what you want to accomplish but you can play with the cell formatting (or format and entire row/column by selecting it) and selecting Format > Cells. Make sure the Number tab is selected and look for the format that works best for you.

Quote:

---

Originally Posted by WKMAHESH

In Excell, I want to put any value of figure in word. e.g. as in cheque there is figure in numeric as well as in word ie "Rs 45010/-" where is Rs is currency symbole in India this is in word will be "Rupees fourtyfive thousand ten ". I want convert the numeric figure in word in other cell .

---

There is no built in function to do this. You need do this in VBA by creating a function.

The following article shows code to do it. You may need to modify it for your own usage.

http://support.microsoft.com/kb/213360/en-us