To get Excel figures in Indian Rs.

Right click a cell>Select Format Cells>In Number Tab>Select Custom Option>In the box under the “Type” word paste the following codes as per need




If result is desired in crores: - ##\,##\,##\,##0.00



If Results is desired in Lakhs: - ##\,##\,##0.00;##,##0.00





But remember this trick will work only in case you have positive numbers in cell i.e if anything is below 0 in a cell this trick won’t work on same.



For the next time these two formulas will get stored as last available option in custom menu.



Disadvantage of this trick.



Since the formats of cells have been changed to custom it may not give effect to results in case addition/subtraction etc is done with a cell of a different format. But I have checked its compatibility with quite a few formats and it works just fine.