2007 ButtonExcel OptionsAdvancedEditing optionsUncheck Use System
Separators. Use comma for decimal point.

Same in 2003 under ToolsOptionsInternational


Gord Dibben MS Excel MVP

On Tue, 11 May 2010 07:01:01 -0700, Radhakant Panigrahi
wrote:

I have the below amount with me

50,862.82
73,820.42
107,363.57
1,156,634.06
In the above amounts virtually there is no “,” in between the numbers.
I have to put “,” where there is “." (Point) and this can be done with
replacing (CTRL+H).
And I need to put “." (Point) in each thousand separator like below.
50.862,82
73.820,42
107.363,57
1.156.634,06
Is there any solution for this.

Regards,
rkp