View Full Version : How to get words of figures in Excel
WKMAHESH
Feb 28, 2006, 11:35 AM
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 .[/
NeedKarma
Feb 28, 2006, 11:39 AM
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.
ScottGem
Feb 28, 2006, 12:32 PM
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