How to get figures in the Indian rupee format
Rupees with Paise
[>9999999]"Rs. "##\,##\,##\,##0.00;[>99999]"Rs. "##\,##\,##0.00;"Rs.
"##,##0.00
Rupees without Paise
[>9999999]"Rs. "##\,##\,##\,##0;[>99999]"Rs."##\,##\,##0;"Rs. "##,##0
Rupees without Rs. notation
[>9999999]##\,##\,##\,##0.00;[>99999]##\,##\,##0.00;##,##0.00
How to create a short key to insert indian rupee sign in excell sheet with out any hassle?
1. Select the cells where you want currencies to be dispalyed.
2. Now right click and select "Format Cells".
3. Now on the Number Tab Select "Currency" option.
4. Now Click on the drop-down list of "Symbol" and select "Rs" from the list
5. You are done
Hope this helps,
CynosureboY
To convert numerical values in words... ex:MUR3450.45 into Rupees Three thousand four hundred and fifty and cents forty five only.
Convertion should be made in Mauritian rupees
SOURCE: Cant get the Indian rupee
there is a popular solution for those who have been locked out by excel spreadsheet. For this solution, what you need is a password recovery tool,Google Excel Password Recovery 5.0 for password recovery. Download and install the software.
With Excel Password Recovery 5.0, you can open you excel spreadsheet without data lost.
SOURCE: how to format cell to
Hi,
You need to right click on the cell and click on:
Format Cells, Number Tab, Currency, Select Rs.
That will convert the cell to display INR.
If you require any further assistance, please comment and let me know, and I will be happy to assist you to further resolve your issue.
I will appreciate your feedback and positive rating for this solution.
Thank you.
17,188 views
Usually answered in minutes!
×