![]() In the example below, the point is not recognized as a decimal point. You can find the button here (I use Office for Mac, so it might look different for you): The solution is to apply the Text to columns to the erroneous column again. The case here is that the number value is not recognized correctly, for instance a field contains 24.67 and Excel thinks it’s not a number. I do not understand why there is no feature in Office to interpret a field as a number regardless of the decimal separator, but fortunately there is a workaround. Regional settings and the use of decimals can be a real pain, especially when importing data from various sources. Usually the solution is to change decimal settings in Excel, or even in your operating system (regional settings). It’s also very useful for converting decimals. ![]() Usually I paste csv or other delimited data in the first column, and use the Text to Column wizard to convert it to individual columns. I frequently use the “text to columns” feature in MS Office 2007 and higher.
0 Comments
Leave a Reply. |