Creating a CSV file from Excel and retaining the character format of a column that has all numeric
I have an excel spreadsheet that is defined as character, however the columns that have numeric are converting to scientific format.
The file looks fine when opened in notepad, however once opened in Excel the format changes.
The file was created in SAS Enterprise Guide.
Solution:
Adjust the displayed format within Excel, the CSV is not at fault.