Thousand Separator- How to Change

[arunjhalani]

I need to change the Thousand separator grouping.

E.g 10,000,000 is to displayed as 1,00,00,000. This is because I have this system followed in our area. I am not able to change this in Custom format Properties.
Thanks in advance

Arun J

 

[arunjhalani]

That is right upto 10,00,00,000 when I go beyond that the formats fails it shows 100,00,00,000 where as it should show 1,00,00,00,000 and there after every two zero should be grouped.
that is why in my earlier post I had said this.

Thanks for your suggestions

 

[Andrew Poulsom]

That would require a third condition like:

[>=1000000000]##\,##\,##\,##\,###.00

but only 2 are allowed.

Why do you need such large numbers? You could scale them down to 000's using:

[>=10000000000]##\,##\,##\,###.00000,;[>=100000000]##\,##\,###.00000,;#,##0.00000,

 

[Barry Katcher]

Nice format, Andrew.

 

[arunjhalani]

YA No need to write those big nos, But The Requirement was that
Thanks Andrew
Ques remains we can limit the lower condition of 100000 but uper condition cant be kept open ?? if that could have been, the leading comma's can't be eliminated.

Well its long thread. Thank u all.

 

[aniltandon]

Could You please provide the format common for both Positive and negative, the format is applicable for positive number only but not working for negative.

Anil Tandon