Forum Discussion
Solved
Prevent Excel from adding = to CSV files upon opening?
In our learning management system, we have to add a hyphen to the front of some online course titles to ensure they are sorted properly in the catalog. (A hyphen must be used because it is one of the...
Do not open CSV files with Excel. Instead import them, either with the text import assistant or with Power Query (best choice!) and set the data type to text for this field.
Do not open CSV files with Excel. Instead import them, either with the text import assistant or with Power Query (best choice!) and set the data type to text for this field.
Detlef_Lewin -- Thank you for your prompt and very helpful response! I had no idea you can import data from a CSV instead of open it, but this seems to be have worked! I'll convey these steps to our LMS administrator. Much appreciated! LSpirko
