Currency Format(INR)

Can we convert Currency into INR(Indian Rupees, Ex: 1,00,000) using FormatCurrency()?

Hello Hello, 

Here is the documentation link regarding the FormatCurrency function:

Best regards, 



Using FormatCurrency() will give you following results:

 Hence the comma will be after every 3 digits.

Thanks Mohd Anees Mansoori ,

But Can we convert 1000000 into 10,00,000  instead of 1,000,000 ?

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.