Convert comma to decimel to separte the number

[kumar1803]

Hi
I have some funky numbers where I see only comma and not decimal

[TABLE="width: 111"]
<tbody>[TR]
[TD]296,86[/TD]
[/TR]
[TR]
[TD]5780,154,295,96

As you see there are all comma in the numbers above.

296,86 should be 296.86[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]

 

[Scott Huish]

Perhaps:
=SUBSTITUTE(A1,",","")/100

Copy down.
Format as Number with 2 decimal places

Excel 2010
	A	B
1	296,86	296.86
2	5780,154,295,96	5780154295.96
Sheet1

Cell Formulas
Range	Formula
B1	=SUBSTITUTE(A1,",","")/100
B2	=SUBSTITUTE(A2,",","")/100