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 is always better if you insert a file (without sensitive data) and also know the Excel version and operating system from the start. You have to make life even harder for the others who want to help, unless you don't want a solution.
Formula (english)=VALUE(A2)*1
Formel (German)==WERT(A2)*1
In the inserted file you will find an example on your values / sheet
If I may recommend that you read Mr. Cuong's post, the first message is in this forum.
There you can see the guidelines that will help you faster and more effectively.
Thank you for your patience and time.
Nikolino
I know I don't know anything (Socrates)
- there is no sensitive data in the file, & the file is from germany
My problem is that all the methods for converting are not working, this why am askingText to Columns shall work in your case. If by formula, you may use
=NUMBERVALUE(A2,",",".")Please check attached.
- strange why on my pc, its not working, its just giving an error #value
first time i face such issue that even text to column is not working, i tried also to change locale in the formatting of date to make it as original, but still its not working
