I have an issue with a .csv file that is an export from a user intranet site. The user simply selects 'Export' from the site and the export opens Excel automatically. The issue is that Excel handles it two different ways depending on the user and what I assume is a default setting.
Version 1: File opens in Excel with all data in column A with comma delimiters. This is the expected process. A simple text to columns which allows the user to change one column to text (part numbers have leading zeroes) and the export to Excel is perfect.
Version 2: File opens in Excel but the system somehow is recognizing the comma delimiters and does the column split automatically. This is not preferred as the item number is not changed to text so the leading zeroes are truncated.
Any ideas how to change a setting that makes version 1 happen? The solution needs to be fairly simple because there are hundreds of external users accessing this data that is specific to them.
By the way - all the users tested so far are all on same version of Excel 2010. External users will likely be on anything 2007 and newer.