SpreadSheet Solutions

   INTRODUCTION   The purpose of using excel is to analyze data and make informed decision. The analysis is based on the underlying data and its proper formatting and it becomes even more important as the input data gets larger. If you are doing the analysis, it is likely that some one else is doing the data entry for you or you are importing data from other sources such as *.csv or *.txt format over which you have no control. In both the cases, there are chances that the raw data that you will get is not perfectly suitable of analysis right away. In most cases, there are some inadvertent error which are made during data entry which require some sanitation or cleaning before the analysis.  You may face common errors as under: Inclusion of non-printable characters such as line break. This causes the text data to appear in zig zag manner and it is frustrating to remove such characters manually.  Multiple spaces or extra spaces in a sentence which can make your life difficult as the word

      Well, the better way to use Indian Style commas while working in MS Excel is to change the 'Region and Language' Setting of your Windows system. However, there is another work around in MS Excel to automatically add commas to number in Indian Style i.e. first comma at three digits and then the subsequent commas are at interval of 2 digits. For instance, 1,000,000 will appear as 10,00,000. This is particularly useful when you are working with currency in INR.   Steps to follow:     1. Select the range which needs to be formatted. Let's take the following sample data which uses the default 1000 comma separator :       2. Press Ctrl + 1. This will open the number format dialog box and then select Custom category shown below.          3.     The add the this custom number format string [>1000000]"Rs" #\,##\,##\,##0"/-";[>=100000] "Rs "##\,##\,##0"/-";"Rs "##,##0"/-" into the 'Type Text Box' as show