I have multiple columns and rows of the following number types imported into excel worksheet, from a text file:
They look like the format used in European data, but are saved as text. Excel seems to be reading the thousands separator (.) as the decimal point.
I need to convert these into numbers Excel can use (i.e. 1127.8 and 1140.1) to progress with further calculations. Some of the conversions I've already tried, give the wrong result. For example if you add these numbers I get 2.267 and not the correct value of 2267.9.
Prior related question: http:Q_28631627.html