If you want ten lakhs in an Excel sheet in figures, it will appear as 1,000,000. To avoid this, go to the cell format and select custom. Enter the following format: ##",","##0. Now it will look like 10,00,000.
That's really helpful. I was not clear with VLOOKUP and HLOOKUP commands. Thanks for sharing the info.
Regards,
Mony
If you are knowledgeable about any fact, resource or experience related to this topic - please add your views. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone. Join To Contribute