| A | B | |
|---|---|---|
1 | Amount in Figure into Words (Indian Rupees) | |
2 | If anybody wants to get the amount in figure in Indian Rupee in to words , here is a single cell formula created by me for this. The amount below ₹ 100 Crore can be converted to words. The amount should be entered in the cell B3 without any space, comma, hyphen, slash , letters etc. If you want to operate this formula in your own sheet, the cell reference B3 can be changed by 'Find and Replace' method . The formula works in google sheets as well as in LibreOffice Calc. | |
3 | Enter Amount in Figure=> | ₹6,310.90 |
4 | Amount in Words=> | Six Thousand Three Hundred and Ten Rupees and Ninety Paise Only |
5 | Formula created by Ajesh P G, Kannur, Kerala, India | |
6 | E-mail: apg29m83@gmail.com | |