VBA - decimal separator issue

I know sometimes to get text cells to turn into number cells you have to do a math problem with them.
There are two ways that I know of, just add zero to the number or multiply by one.
Without a sample sheet I can't tell you how to do it but maybe format another column as numbers and then use a formula referring to the cells showing as text and multiple the reference by 1 or add 0, whatever is your preference.
You could then change those formulas to values and paste them back into the original cell.
I would just try one cell that's an issue first not all of them.

Hello. A re-question, StingerMKO: is this information obtained after "copying and pasting" from the internet?...

I ask you because, in addition to what you can often see, there is a character (160) that looks like the space character (32) but is not the same and complicates the normalization of those numbers.

I also suggest that you upload a workbook to the Forum with several of these numbers to better analyze them.

Originally Posted by Marc L

Hi,

or just using Cell.Formula = Cell.Value …

This did not work, 0*Value of the cell results in the same value and same issue after switching from "." to ","

Originally Posted by skywriter

I know sometimes to get text cells to turn into number cells you have to do a math problem with them.
There are two ways that I know of, just add zero to the number or multiply by one.
Without a sample sheet I can't tell you how to do it but maybe format another column as numbers and then use a formula referring to the cells showing as text and multiple the reference by 1 or add 0, whatever is your preference.
You could then change those formulas to values and paste them back into the original cell.
I would just try one cell that's an issue first not all of them.

This also did not work, same value/issue after this.

Originally Posted by mjr veverka

Get the data from the columns to the array variable and process with the "Val" function - copy the data from the variable back to the sheet, but before re-copy do formatting the columns to the "General" format.

This finally did the trick and now all the numbers are automatically in the correct decimal format with "," as deliminter. Thank you!