I am trying to create a formula which will calculate Rupees from USD. However, I cannot find a way to get the formatting correct. The Rupee is typically formatted 10,00,000. While I have seen macros to spell this, I can't find a way to numerically format the result correctly. I realize if I change the Country settings, it will apply to the entire workbook, not just a section of it.