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


"samahoque" wrote in message
...
|
| 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...o&userid=37227
| View this thread: http://www.excelforum.com/showthread...hreadid=569376
|