hi all,
i wrote this problem to other forum, but there nobody help me.
http://www.excelforum.com/excel-prog...ve-format.html
Pls. can you help me here?
---------------
I want change numbers in format with dots to format without dots. Now it doesnt works good.
How i use it:
I copy a lot of numbers in "bad format (with dots) in excel, then select all numbers and run macro.
f.e.:
10.205.356,46
to
10 205 356,46
this code doesnt works good. If is in the number only comma without dot, it multiply the number by 100
What is wrong in this code please?
Sub dot()
'
Const erate = 1
Dim cell As Range
Application.ScreenUpdating = False
For Each cell In Selection
Selection.Replace What:=".", Replacement:="", LookAt:=xlPart, SearchOrder:= _
xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False
Next cell
For Each cell In Selection
If IsNumeric(cell.Value) And LenB(cell.Value) Then cell.Value = cell.Value * erate
Application.ScreenUpdating = True
Next cell
Selection.NumberFormat = "#,##0.00"
End Sub
in atach is example the RED number convert wrong