How to covert an amount in Indian rupees in figure automatically to words in spreadsheets like M S Excel, Google sheets, Libreoffice Calc etc?
In this post I am going to introduce a spreadsheet formula to convert rupee amount in indian rupees to words which is working in commonly used spreadsheets like MS Excel, Google Sheets and Libreoffice Calc etc. It is a single cell formula created by me myself. The formula is much more lengthy, but it works. The cell reference should be B3 . The cell number format should be changed to 'plain text'. There should not be any space, unwanted characters in between numbers, but a decimal point and two places needed. This formula is not tested well. So sometimes it may cause errors. A sample spread sheet and formula document is given below Sample speadsheet Formula document