Excel Not Accepting my Regional Formating.

R

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?
 
N

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


|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?
|
 
Top