use 100 seperator instead of 1000 in excel
 

I have change the setting of digt group under Number & Curency tab in
regional setting in control panel from 123,456,789.00 to 12,34,56,789.00. But
still I could not able to use the update changes setting in digit group. How
can I use my update digit group setting.

use 100 seperator instead of 1000 in excel
 

Montu,

Use a custom format of


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

will format say 1234567890 as 123,45,67,890.00

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Montu" wrote in message
...
I have change the setting of digt group under Number & Curency tab in
regional setting in control panel from 123,456,789.00 to 12,34,56,789.00.
But
still I could not able to use the update changes setting in digit group.
How
can I use my update digit group setting.

use 100 seperator instead of 1000 in excel
 

Thank you for your suggestion. I knew about custom format. I just want to
know what is the utility of change the setting of digit group in regional
setting in control panel. Would you tell me what is the process to work in
change setting of digit group or Is there any way to work as per my setting
instead of custom format. Thanks in advance

"Bob Phillips" wrote:

Montu,

Use a custom format of


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

will format say 1234567890 as 123,45,67,890.00

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Montu" wrote in message
...
I have change the setting of digt group under Number & Curency tab in
regional setting in control panel from 123,456,789.00 to 12,34,56,789.00.
But
still I could not able to use the update changes setting in digit group.
How
can I use my update digit group setting.

use 100 seperator instead of 1000 in excel
 

It's under Digit Grouping.

On Dec 21, 12:19 am, Montu wrote:
Thank you for your suggestion. I knew about custom format. I just want to
know what is the utility of change the setting of digit group in regional
setting in control panel. Would you tell me what is the process to work in
change setting of digit group or Is there any way to work as per my setting
instead of custom format. Thanks in advance

"Bob Phillips" wrote:
Montu,

Use a custom format of

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

will format say 1234567890 as 123,45,67,890.00

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Montu" wrote in message
...
I have change the setting of digt group under Number & Curency tab in
regional setting in control panel from 123,456,789.00 to 12,34,56,789.00.
But
still I could not able to use the update changes setting in digit group.
How
can I use my update digit group setting.