This was the most irritating moment while preparing for my computer practical examination. Microsoft Excel simply refused to accept the Rs (Rupees, the currency in India) text before the numbers, so it refused to calculate further. Not only for me, but for many other people in different countries will definitely face this problem. How to correct this? Chuck Office 07 out of the Windows (pun intended) hard-drive? Nah, that’s impossible. Although you all hate Microsoft for various reasons, you’ll have to agree that Office 07 is one of the finest office suites around. Even if it costs a fortune you are ready to download via a torrent buy a copy. But then, Microsoft is biased towards its US customers 😦
So here’s how to correct it.
1] Hit Start. Now, click on Control Panel.
2] Now, by default, you should see the Category View. If not, switch to Category View from the Control Panel sidebar.
3] Once you’re in the category view, click Date, Time, Language, and Regional Options.
3] Click Change the format of numbers, dates, and times.
4] See the format set for the United States? Change it to your own country. Since India uses the United Kingdom system of numbers, units, et cetera, I’ll choose that.
5] After you choose, click Apply. Now, click Customize…
6] In the Numbers tab, I changed the digit grouping from 123,456,789 to 12,34,56,789. You do so if you wish. Click Apply and go to the Currency tab.
7] Here’s why we came here for. I changed the currency symbol to Rs. Remember to put a space after typing Rs, otherwise, you’ll see the numbers stuck to the symbol. Click Apply. Change the Time and Date if you want, and if you do, remember to click Apply. Click OK, and exit.
And now, whopee!