software

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
A Google search is a good place to start with questions. The first
entry in a search of Microsoft.public.excel.* groups for quot;Indian commaquot;
looks promising

groups.google.com/group/micro...bf439d68bbad02

Jerry

R Kapoor wrote:

gt; I require to format my excel sheet using Indian system of formatting number
gt; to use thousand separators which is like ##,##,##,##0.00 and not as
gt; ###,###,##0.00.
gt;
gt; I have already changed the regional settings in Windows Contol Panel
gt; suitably and checked the suitable option in Excel/Tools/Options to select
gt; thousand separator as per system settings.
gt;
gt; Still my number are formatted as ###,###,##0.00
gt;
gt; Even custom setting to ##,##,##,##0.00 gets reverted to ###,###,##0.00Use a custom format of

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

--

HTH

RP
(remove nothere from the email address if mailing direct)quot;R Kapoorquot; lt;R gt; wrote in message
...
gt; I require to format my excel sheet using Indian system of formatting
number
gt; to use thousand separators which is like ##,##,##,##0.00 and not as
gt; ###,###,##0.00.
gt;
gt; I have already changed the regional settings in Windows Contol Panel
gt; suitably and checked the suitable option in Excel/Tools/Options to select
gt; thousand separator as per system settings.
gt;
gt; Still my number are formatted as ###,###,##0.00
gt;
gt; Even custom setting to ##,##,##,##0.00 gets reverted to ###,###,##0.00
gt;
gt;
Jerry,
The link does not solve the problem as I am using Excel 2003 under Windows
XP Professional. This version of windows provides for Indian Commas Style,
which I have selected in the Windows Regional Settings.

The point is that Excel is not using this setting. Is it a bug? Should Excel
not be using the thousand separators as defined under Regional Settings in
Windows? Or am I missing something.

quot;R Kapoorquot; wrote:

gt; I require to format my excel sheet using Indian system of formatting number
gt; to use thousand separators which is like ##,##,##,##0.00 and not as
gt; ###,###,##0.00.
gt;
gt; I have already changed the regional settings in Windows Contol Panel
gt; suitably and checked the suitable option in Excel/Tools/Options to select
gt; thousand separator as per system settings.
gt;
gt; Still my number are formatted as ###,###,##0.00
gt;
gt; Even custom setting to ##,##,##,##0.00 gets reverted to ###,###,##0.00
gt;
gt;

Did you try the custom format from my link, which Bob Phillips reproduced in
this thread? It works fine for me in Excel 2003. The trick is to use quot;\,quot;
instead of just quot;,quot; in the custom format.

Jerry

quot;R Kapoorquot; wrote:

gt; Jerry,
gt; The link does not solve the problem as I am using Excel 2003 under Windows
gt; XP Professional. This version of windows provides for Indian Commas Style,
gt; which I have selected in the Windows Regional Settings.
gt;
gt; The point is that Excel is not using this setting. Is it a bug? Should Excel
gt; not be using the thousand separators as defined under Regional Settings in
gt; Windows? Or am I missing something.
gt;
gt; quot;R Kapoorquot; wrote:
gt;
gt; gt; I require to format my excel sheet using Indian system of formatting number
gt; gt; to use thousand separators which is like ##,##,##,##0.00 and not as
gt; gt; ###,###,##0.00.
gt; gt;
gt; gt; I have already changed the regional settings in Windows Contol Panel
gt; gt; suitably and checked the suitable option in Excel/Tools/Options to select
gt; gt; thousand separator as per system settings.
gt; gt;
gt; gt; Still my number are formatted as ###,###,##0.00
gt; gt;
gt; gt; Even custom setting to ##,##,##,##0.00 gets reverted to ###,###,##0.00

Jerry,

While I agree that the custom format described by you work, the point here
is why is excel not picking up the format from the system settings. Excel
2003 is supposed to this. Right?quot;Jerry W. Lewisquot; wrote:

gt; Did you try the custom format from my link, which Bob Phillips reproduced in
gt; this thread? It works fine for me in Excel 2003. The trick is to use quot;\,quot;
gt; instead of just quot;,quot; in the custom format.
gt;
gt; Jerry
gt;
gt; quot;R Kapoorquot; wrote:
gt;
gt; gt; Jerry,
gt; gt; The link does not solve the problem as I am using Excel 2003 under Windows
gt; gt; XP Professional. This version of windows provides for Indian Commas Style,
gt; gt; which I have selected in the Windows Regional Settings.
gt; gt;
gt; gt; The point is that Excel is not using this setting. Is it a bug? Should Excel
gt; gt; not be using the thousand separators as defined under Regional Settings in
gt; gt; Windows? Or am I missing something.
gt; gt;
gt; gt; quot;R Kapoorquot; wrote:
gt; gt;
gt; gt; gt; I require to format my excel sheet using Indian system of formatting number
gt; gt; gt; to use thousand separators which is like ##,##,##,##0.00 and not as
gt; gt; gt; ###,###,##0.00.
gt; gt; gt;
gt; gt; gt; I have already changed the regional settings in Windows Contol Panel
gt; gt; gt; suitably and checked the suitable option in Excel/Tools/Options to select
gt; gt; gt; thousand separator as per system settings.
gt; gt; gt;
gt; gt; gt; Still my number are formatted as ###,###,##0.00
gt; gt; gt;
gt; gt; gt; Even custom setting to ##,##,##,##0.00 gets reverted to ###,###,##0.00