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