I converted a text file to an excel file and found several numbers stored as text with . (period) as thousand separators and , (comma) as decimal separator. And worse, some negative signs is appearing on the right side of the number. (It actually looks like this, 1.566,56-. Correct format should be 1,566.56 as numbers and with enclosed in parenthesis if negative)
Is there a formula how to convert these "text-numbers" into "numbers" with the correct format ( comma as thousand separator and period as decimal separator)? I tried formatting it from Format Cells but nothing happens.
Please help