use 100 seperator instead of 1000 in excel

[Montu]

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.

 

[Bob Phillips]

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]

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

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)

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.

 

[iliace]

It's under Digit Grouping.

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

Montu,

Use a custom format of

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

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

Bob

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