Hi everyone,
I have a column with numeric values that, to set the decimals, have the dot rather than the comma.
To replace all the points with commas, I inserted this part into a macro.
The macro therefore replaces all values, the problem is that the values of these cells are not read as numeric values (which can be added together).
To make them become numeric value, so you can add them up, I have to click on each cell.
At that point the content of the cell automatically moves from left to right and these values become summable between them.
Is there a way to avoid this "click" step on each cell? I hope I explained myself. Thank you !
Columns("S:S").Select
Selection.Replace What:=".", Replacement:=",", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Bookmarks