Changes

Jump to: navigation, search

Open CSV in Excel

194 bytes added, 13:39, 5 April 2015
no edit summary
<li>Use function ''Text to columns'' on Data ribbon.</li>
</ol>
Same steps <li>The wizard starts.</li>[[Image:Csv wizard1.png|500px|center]]
<div align="center">
'' Country The first panel''
</div>
<li>Click '''Next'''.</li>Change ''Delimiters'' to '''Comma'''[[Image:Csv wizard2.png|500px|center]]
<div align="center">
'' Country The second panel''
</div>
<li>Click Change ''Delimiters'' to '''NextComma'''.</li><li>Change Click ''Column data format'' to Next''Text'' and verify that the format is set.</li>[[Image:Csv wizard3.png|500px|center]]
<div align="center">
'' Country The third panel''
</div>
<li>Change ''Column data format'' to '''Text''' and verify that the format is set to '''Text''' for the columns that Excel otherwise will change to the wrong data type or data format.</li><li>Click '''Finish'''.</li><li>Save as xlsx.</li><li>Close and open the file in order to verify that the data still has the correct format.</li>
</ol>
{{NavBox Technical Notes}}
[[Category:NAA]]
6,632
edits

Navigation menu