I have a report that is exported from a system into a .csv file format. There is a field in the report that contains values separated by commas after every seven characters. For some reason, when the file is opened in Excel, excel converts this field to a number type field and so the commas end up being shifted, and the integrity of the values in the field is lost. Is there a way to prevent excel from converting this field when the file is opened so that the integrity of the values contained in the field of the report is maintained?
This is what the field in the file should look like: