display 10,000,000.00 as 1,00,00,000.00
 

general question

see other thread.

--
HTH

Bob Phillips

"debiprasad" wrote in message
...
general question

This is the indian number format. copy paste this format into the custom
number format
[9999999.99]##\,##\,##\,##0.00;[99999.99]##\,##\,##0.00;##,##0.00

I find it useful to search google or this group for whatever help you
require, it is usually already available.

Regards

Neil

"debiprasad" wrote:

general question