Bob,

Today I discovered something. I was at the Control Panel, looking at regional and language options. I clicked on "customize" and clicked on the down arrow beside digit grouping. The last option from the list is interesting. It is related to this thread. I wonder which regions use this format. If I choose (of course I won't) the last option, all MS Office software and not just Excel will be affected, right?

If the poster's region uses this format all the time, do you see a problem if he/she changes the digit grouping to the last option? This is provided the option is there for him/her to choose from.

Just curious. I am always happy and want to tell when I have discovered something. But, of course I don't expect the same level of joy from others who have known all along ...... ;)

Epinn

"Bob Phillips" wrote in message ...

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

"eereokatohar" wrote in message
...
Sir ,
i want to numbers written in cells be displayed as grouped in indian
format
i.e. a number of 123456.00 can how be automatically group as 1,23,456.00
instead of 123,456.00