when re-formatting csv data to a table in excel, values above 1 are always formatted as dates (Feb 2nd instead of 2.2). Changing format in format cells menu then changes the values to "43831". Any idea how I can get the right format for a row of 50,000 lines?
The workaround is not to open csv in Excel, but import csv to Excel, parser will work by different way. Depends on Excel version and your preferences you may use legacy import, in it on third step assign Text to such columns. The same if import by Power Query, transform and use Text type.