Excel Not Accepting my Regional Formating.

[Rahul Gupta]

I am using windows Xp sp2 and office 2003 sp2.


I have set up operating system’s regional settings to group digits like :
12,34,54,789.00. But excel does not format my currency like this.

Can any one tell me what I missed out?

[Niek Otten]

Format Custom as

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

Or use

http://groups.google.com/advanced_group_search

and look for Indian

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Rahul Gupta" <[email protected]> wrote in message news:[email protected]...
|I am using windows Xp sp2 and office 2003 sp2.
|
|
| I have set up operating system's regional settings to group digits like :
| 12,34,54,789.00. But excel does not format my currency like this.
|
| Can any one tell me what I missed out?
|