Forum Discussion
why text values are not converting to numbers
Usually Excel do all transformations from from one locale to another automatically. Issues could be if people use texts instead of formatted, includes as dates or as currency, numbers. Or if you import text files. In which locale file was created that's only if check how such texts are formatted.
If you is able to have numbers by changing of advanced settings, when Text to Columns definitely shall work without such change. I have no idea why it didn't work in your case, if only on thirds stage of the wizard you have misprint in Advanced setting for decimal / thousand separator, or set them as for your locale, not as they are for source locale.
Convert numbers stored as text to numbers
Numbers that are stored as text can cause unexpected results. Select the cells, and then click
to choose a convert option. Or, do the following if that button isn't available.
Use Paste Special and Multiply
If the steps above didn't work, you can use this method, which can be used if you're trying to convert more than one column of text.
Select a blank cell that doesn't have this problem, type the number 1 into it, and then press Enter.
Press CTRL + C to copy the cell.
Select the cells that have numbers stored as text.
On the Home tab, click Paste > Paste Special.
Click Multiply, and then click OK. Excel multiplies each cell by 1, and in doing so, converts the text to numbers.
Press CTRL + 1. Then select any format.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
