Could you please have look the attached file, basically its A column is a download from an outer system.
You can see for example in cells A4 or A20, that the download saved the quantities in such format
My target would be to replace the "." characters so getting
Basically I have a macro which I assume should do it, but this creates the cell values like 1774000 and 5100000 on the example
[A:A].Replace ".", vbNullString
Could you please advise how this code should be modified to bring the quantities according to the target? It is interesting because selecting menu Edit/Replace and Find what "." to replace with nothing, that works