replace point by coma macro in a range
replace point by coma macro in a range
(OP)
Hi All,
my int setting for decimal is point (.)
I need a CSV file, made from excel, to have coma (,) instead of point(.).
I donno why but for low value it works
0.254 => 0,254 as text (good)
but for higher value it doesnt work
123456.789 => 12 356 789 as value (bad)
when i dont use the macro but the replace function it works...
the code is :
Range("A1:D5").Select
Selection.Replace What:=".", Replacement:=",", LookAt:=xlPart, SearchOrder:=xlByRows,_ MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False
thanks
my int setting for decimal is point (.)
I need a CSV file, made from excel, to have coma (,) instead of point(.).
I donno why but for low value it works
0.254 => 0,254 as text (good)
but for higher value it doesnt work
123456.789 => 12 356 789 as value (bad)
when i dont use the macro but the replace function it works...

the code is :
Range("A1:D5").Select
Selection.Replace What:=".", Replacement:=",", LookAt:=xlPart, SearchOrder:=xlByRows,_ MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False
thanks
Have fun,
Eric
catiav5@softhome.net





RE: replace point by coma macro in a range
<Digital symbol> = ,
<Digital grouping> = (select the value with no , or .)
<List Seperator> = ,
Apply or Ok
Start excel and enter some values, then export to .csv!
It works fore me.
P.S.
I work with XP, Regional Settings maybe different in W98, NT
RE: replace point by coma macro in a range
this is not really what i ask for.
what if i dont want to change INT settings ?
Have fun,
Eric
catiav5@softhome.net