Formatting for Indian Rupees
 

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

Formatting for Indian Rupees
 

[=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)

"Macshell" wrote in message
...
How can I change the comma location to reflect Indian Rupees?

Formatting for Indian Rupees
 

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

"Macshell" wrote:

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