Forum Discussion
Excel data import_Wrong numbers
Hello, I'm having big problems importing data to excel. I import point values from a txt file. Instead of a number, it inserts a date for me. If I insert the data as a number, it inserts com...
SStudio2015 Do NOT copy and paste directly from the txt file, but use Data, From Text/CSV or Data, Get Data, Legacy Wizards, From Text.
The first option opens the Power Query editor and may be a bit overwhelming if you haven't used it before. The second option opens a straight forward wizard that guides you through an import process. In step three it's important that you correctly set the data type for each column.