Hi Experts
I have a column that has data like:
20873,1679,20274,110620,110617,110618,110619,110616,110614
I have a VBA function that exports to a CSV file however this is being coverted to:
2.08732E+49
after the export in both the CSV file and also if I open with EXCEL. In the table the column is formatted as TEXT and unfortuantely the program this data is uploaded to use "," as the delimeter. Is there a way to retain the data in the text format rather than it being converted to a number after export?
Cheers
Jack
I have a column that has data like:
20873,1679,20274,110620,110617,110618,110619,110616,110614
I have a VBA function that exports to a CSV file however this is being coverted to:
2.08732E+49
after the export in both the CSV file and also if I open with EXCEL. In the table the column is formatted as TEXT and unfortuantely the program this data is uploaded to use "," as the delimeter. Is there a way to retain the data in the text format rather than it being converted to a number after export?
Cheers
Jack