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