- Mar 23, 2017
- Office Version
Hello - i have a VBA that will do a set of commands the end of it will export a sheet that has 1 column with a 9 digit letter/number into CSV. Before exporting the 9 digit presents as it should; but when opening in CSV through XLS it converts some of the data that have an "E" in it to scientific notation. Is there anything i can do prior in my VBA to remove this issue? or do i need to use VBA to reopen the CSV, adjust, and save? would rather the first approach seems after.