Replace point with comma - Numeric value error

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 !

Please Login or Register  to view this content.

Why would you need to replace the default decimal separator with a comma ??????
Seems initially a pointless (no pun intended) exercise if you are summing numerics.
Alternatively alter your regional settings and make the "," the default decimal separator.
A bit messy as you will have to change back to use other workbooks containing the standard separator.
torachan

Those settings are already present, the comma is already configured to be a decimal separator.

I have to replace point with comma and make it readable as if it were an accounting value because otherwise I can't sum the cells

Both with the dot and with the comma, the problem is present. Until I click in the cell, it is not converted to "numerical value"

Firstly what is the cell formated as? If it is text the results would be the same as you have described,

If you format the cells as a number first (even tho they contain text) then do the find and replace as suggested, does this work?

Maybe I found a solution, strange but it's a solution ...

What can I write in VBA to ensure that in the S column you look for cells that ARE NOT EMPTY and multiply the value by 1? :-) This should work

for davsth - I tried to format the cells as numbers or accounting but the problem persists

Hi !

I have differents easy ways but I can't choose any without a workbook attachment !

And how the data come to the worksheet 'cause better than modify cells is to correct the importation …

I try this and it works! :-)
Thanks for your support

Please Login or Register  to view this content.

As it may be done with an unique codeline by at least two different ways just using Excel basics, at child level …

Try

Please Login or Register  to view this content.