Thursday, March 17, 2011

How to Include Indian Currency as Part of the Currency Symbols in Excel


1. Open a Web browser, and navigate to the download page for the Windows Rupee symbol update (support.microsoft.com). Click the download link next to the version of Windows that you have installed.
2. Click the 'Continue' button on the next page. Click 'Continue' again, and save the file 'GenuineCheck.exe' to the desktop. Run the tool, and copy the code displayed into the field under 'Enter your validation code' on the Microsoft Genuine Windows Validation page. Click 'Validate.'
3. Click the 'Download' button, and save the Rupee symbol update to the desktop. Double-click the update file -- depending on the version you downloaded, one possible file name is 'Windows6.0-KB2496898-.msu' -- and wait for the update to complete. Click the 'Restart Now' button to restart your computer.
4. Launch Excel 2010, and click the 'Home' tab in the upper-left corner of the main window.
5. Click the drop-down menu next to the Dollar sign in the 'Number' section of the top toolbar, and then click 'More Accounting Formats.' A new window titled 'Format Cells' appears. Alternatively, select the row or column containing Rupee values, right-click the highlighted cells and select 'Format Cells' to reach this window.
6. Click the drop-down menu next to 'Symbol' and select the Rupee symbol, which should now appear near the top of the list.
7. Click 'OK.' Excel now displays the Rupee symbol next to currency values.

Blogger news