A Google search is a good place to start with questions. The first
entry in a search of Microsoft.public.excel.* groups for "Indian comma"
looks promising
http://groups.google.com/group/micro...bf439d68bbad02
Jerry
R Kapoor wrote:
I require to format my excel sheet using Indian system of formatting number
to use thousand separators which is like ##,##,##,##0.00 and not as
###,###,##0.00.
I have already changed the regional settings in Windows Contol Panel
suitably and checked the suitable option in Excel/Tools/Options to select
thousand separator as per system settings.
Still my number are formatted as ###,###,##0.00
Even custom setting to ##,##,##,##0.00 gets reverted to ###,###,##0.00