Excel Number Format: Indian Style Comma Separation

[Sheeloo]

I am glad you found the code useful. I am not actually familiar with the way Indian money is displayed... does the rupee symbol and the INR go in front or in back of the number? Is there a space separating them? Would you also copy/paste the rupee symbol into your response somewhere so I can see what it looks like?

Hello Rick,

I stumbled upon this link via Microsoft Answers... just in case you still need the information.

The INR symbol is displayed BEFORE the amount. Here is the symbol rupee-symbol-small.jpg

Strangely enough (to the best of my knowledge) there was no symbol till last year. Rs. was used to denote Rupees instead of a symbol.