Officer Finance at JSW Energy Ltd
50 Points
Joined December 2008
Hi,
Use attached formula to write a number into text.
For permanent installation follow these steps
In Excel 2003
Copy this file and
Go to Tools Menu
Click on Add-Ins
Click on Browse
And Paste this file in AddIns Folder and close it.
In Excel 2007
Got to Excel Option
Click on Add Ins
Click onManager Excel Add Ins (Go)
Click on Browse
And Paste this file in AddIns Folder and close it.
Below is the procedure to use this formula.
Number (Cell A1)
|
9999
|
Text Formula
|
=num2text(A1)
|
Result
|
Rupees Nine Thousand Nine hundred Ninety Nine Only
|
|
|