I am importing records into excel by iterating through the field names and values and inserting into a table. Fields are strings, numbers, and dates. The problem is that I have a list of values that are comma separated and I want to insert them into a table as a string but excel keeps converting the cell to number, removing all the commas, and turning the string into one very large number. How can I prevent excel from doing this without affecting other cell formatting for fields that need to be number or date?
Don’t have an account yet? Register yourself now and be a part of our community!