<div>
When openning a CSV file, Excel attempt to guess the data type, and pick the most appropriate one, wich may not be the one you want.<br />
<br />
Solution:<br />
Adjust the displayed format within Excel, the CSV is not at fault.
</div>


When openning a CSV file, Excel attempt to guess the data type, and pick the most appropriate one, wich may not be the one you want.

Solution:
Adjust the displayed format within Excel, the CSV is not at fault.

<div>
You need to open the file in Excel then format the number columns then save as csv file.<br />
<br />

<ol type="1">
<li>Select the cells you want to modify. Selecting a cell range.</li>
<li>Click the drop-down arrow next to the Number Format command on the Home tab. The Number Formatting drop-down menu will appear.</li>
<li>Select the desired formatting option. ...</li>
<li>The selected cells will change to the new formatting style.</li>
</ol>
<br />
For more details read this<br />
<br />
<a href="https://docs.microsoft.com/en-us/office/troubleshoot/excel/format-cells-settings" rel="ugc">How to control and understand settings in the Format Cells dialog box in Excel</a>
</div>


You need to open the file in Excel then format the number columns then save as csv file.


 1. Select the cells you want to modify. Selecting a cell range.
 2. Click the drop-down arrow next to the Number Format command on the Home tab. The Number Formatting drop-down menu will appear.
 3. Select the desired formatting option. ...
 4. The selected cells will change to the new formatting style.


For more details read this

How to control and understand settings in the Format Cells dialog box in Excel [https://docs.microsoft.com/en-us/office/troubleshoot/excel/format-cells-settings]

Advanced Analytics Analyst

morinia

<div>
<div class="content wysiwyg-content">
Creating a CSV file from Excel &nbsp;and retaining the character format of a column that has all numeric<br />
<br />
<br />
<br />
I have an excel spreadsheet that is defined as character, however the columns that have numeric are converting to scientific format.<br />
<br />
The file looks fine when opened in notepad, however once opened in Excel the format changes.<br />
<br />
The file was created in SAS Enterprise Guide.
</div>
</div>


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.

Creating a CSV file from Excel maintaining numbers in character column

The Statistical Analysis System (SAS) programs consist of two steps, the DATA step and the PROC step. The DATA step reads data and prepares it for use by subsequent DATA or PROC steps. A SAS procedure (PROC) is a collection of statements that execute a certain task. SAS procedures have their own statements and commands, but many are shared among procedures. JMP is the graphical user interface for SAS, and is used in applications such as Six Sigma, quality control and engineering, design of experiments and scientific research.

Statistical Analysis System (SAS)

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.