Using Comma in customise option

[samahoque]

Sorry my query is rather long.

We use different comma system in our country (Bangladesh, probably i
India also). Our units and thousands are same like others but for mor
bigger number we use lac (lakh) or crore. For example:

1,00,00,000 this is 'Crore'
1,00,000 this is 'lac' or 'lakh'

When I was trying to use customise cell format using ##,##,##,##0.00 b
selecting the cell either as 'Number' or 'Currency format'. Exce
accepted this code in the format option but in the worksheet this di
not give me the result. Then I went to 'Control panel' and 'numbe
format setting'. Where I changed the currency digit groupping from
drop down option (already there) to 12,34,56,789.

Regioanl Options /customise/currency/digit grouping/12,34,56,789

Here it also accepted this code for the currency and number format bu
in the worksheet it did behave as before ###,###,###.00 (comma at ever
3rd position).

My query can anyone suggest me any option where I could make the Exce
works for our traditional Comma system for the number or currency.

SA

 

[Niek Otten]

Use Google's Group Search:

http://groups.google.com/advanced_group_search


Look in Groups *excel*, search for:


indian number format


You'll find many links, I can't advise you on which one is best!


--
Kind regards,

Niek Otten
Microsoft MVP - Excel


|
| Sorry my query is rather long.
|
| We use different comma system in our country (Bangladesh, probably in
| India also). Our units and thousands are same like others but for more
| bigger number we use lac (lakh) or crore. For example:
|
| 1,00,00,000 this is 'Crore'
| 1,00,000 this is 'lac' or 'lakh'
|
| When I was trying to use customise cell format using ##,##,##,##0.00 by
| selecting the cell either as 'Number' or 'Currency format'. Excel
| accepted this code in the format option but in the worksheet this did
| not give me the result. Then I went to 'Control panel' and 'number
| format setting'. Where I changed the currency digit groupping from a
| drop down option (already there) to 12,34,56,789.
|
| Regioanl Options /customise/currency/digit grouping/12,34,56,789
|
| Here it also accepted this code for the currency and number format but
| in the worksheet it did behave as before ###,###,###.00 (comma at every
| 3rd position).
|
| My query can anyone suggest me any option where I could make the Excel
| works for our traditional Comma system for the number or currency.
|
| SAM
|
|
| --
| samahoque
| ------------------------------------------------------------------------
| samahoque's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=37227
| View this thread: http://www.excelforum.com/showthread.php?threadid=569376
|