Formatting for Indian Rupees

[Guest]

How can I change the comma location to reflect Indian Rupees?

 

[Bob Phillips]

[>=10000000]##\,##\,##\,##0.00;[>=100000]##\,##\,##0.00;##,##0.00

will format say 1234567890 as 123,45,67,890.00


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Guest]

Look under Tools | Options and then on the [International] tab.