How to convert numbers into words in Microsoft excel in Indian Currency format.
I wants to convert numbers into the following format.
1) to convert 12,23,12,123.56 into "Rupees Twelve Crores Twenty Three Lakhs Twelve Thousand One Hundred Twenty Three and Fifty Six Paise Only".
3) to convert 1,01,01,123.56 into "Rupees One Crore One Lakh One Thousand One Hundred Twenty Three and Fifty Six Paise Only".
3) to convert 23,12,123.00 into "Rupees Twenty Three Lakhs Twelve Thousand One Hundred Twenty Three Only".
Please help. Thanks in advance.
- Abhinav Binkar
I wants to convert numbers into the following format.
1) to convert 12,23,12,123.56 into "Rupees Twelve Crores Twenty Three Lakhs Twelve Thousand One Hundred Twenty Three and Fifty Six Paise Only".
3) to convert 1,01,01,123.56 into "Rupees One Crore One Lakh One Thousand One Hundred Twenty Three and Fifty Six Paise Only".
3) to convert 23,12,123.00 into "Rupees Twenty Three Lakhs Twelve Thousand One Hundred Twenty Three Only".
Please help. Thanks in advance.
- Abhinav Binkar