How to get thousand seperator after every two digits

V

Vanga Sasidhar

Hi,

When i enter a number in excel and when thousand separator is
applied it is adding comma after every three digits.

123,345,678.00

But i want to have the comma after every two digits after the first
separator as follows.

12,34,567.00

This is how we in india use. But even though i changed this setting
in Regional and Language Options, it is not at all effecting in excel. i
am using windows XP SP2 and Excel 2003. Please let me know is there
anything else should i change in excel to get this type of setting for
my numbers.

With Regards,
Vanga Sasidhar.
[email protected]
 
B

Bob Phillips

Format the cell as

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

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

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
N

Niek Otten

Use Google's group search:

http://groups.google.com/advanced_group_search

Group: *excel*
Subject: indian number format

You'll find many links, I don't know which one is right!

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi,
|
| When i enter a number in excel and when thousand separator is
| applied it is adding comma after every three digits.
|
| 123,345,678.00
|
| But i want to have the comma after every two digits after the first
| separator as follows.
|
| 12,34,567.00
|
| This is how we in india use. But even though i changed this setting
| in Regional and Language Options, it is not at all effecting in excel. i
| am using windows XP SP2 and Excel 2003. Please let me know is there
| anything else should i change in excel to get this type of setting for
| my numbers.
|
| With Regards,
| Vanga Sasidhar.
| [email protected]
 
Top