Use a custom format of

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"SVC" wrote in message
...
Hi!

sample number 123456789
In excel normally numbers are seprated in 1000's format ie 123,456,789.00

I NEED IT IN this format (indian style of rupees) 12,34,56,789