anebo si na to napiš makro 
Sub Nahradminus()
'
Cells.Select
Selection.Replace What:=",-", Replacement:="", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Cells.Select
Selection.NumberFormat = "#,##0.00"
End Subedit: jsem to ale trouba
až napočtvrté jsem to optimalizoval 