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.
My problem is that all the methods for converting are not working, this why am asking
Text 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- Hi again, it worked when i changed my advanced settings for . as thousand seperator & , as decimal
My question, is there an automatic way to detect locale, like if i frequently get files from other regions, i should manually modify it each time? and as i understand if i modify it, this setting will be active for my future files unless i change it, its not a setting for the current workbook/fileUsually 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.