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.
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
This fix is courtesy of CynosureboY
SOURCE: IN EXCEL HOW TO CUSTOMISE
Hi
Select Any single cell or group of cell, Right click --> Context menu will be displayed ----> Select Format Cells options --->in Format cell Windows Under Number Tab in the Category Section Select Currency and Under Symbol List Select Rs or INR as Indian Rupee Currency .and then Click okay Button
Regards
Ramsoft
262 views
Usually answered in minutes!
×