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.
It depends on in which locale you are, more concrete what are your thousand and decimal separators.
You may select column O, Data->Text to Columns, and on third step select comma as thousand, dot as decimal separator.
Result is numbers
Alternatively you may change them in File->Options
but that affects all your Excel files.
SergeiBaklan I tried all methods that i know to convert to number, but its not working, did you ever faced such problem? i never had an issue like that
I will attach the file , thanks