NoPublic, bureaucrat, administrator
6,632
edits
Changes
Created page with "{{Warning | When you open the CSV file in Excel, Excel will automatically interpret data like '''1-10''' as '''10-Jan'''. Therefore check carefully the result in Excel before..."
{{Warning | When you open the CSV file in Excel, Excel will automatically interpret data like '''1-10''' as '''10-Jan'''.
Therefore check carefully the result in Excel before sharing the export result with others. This page describes a word around for this Excel behaviour.}}
Export
Open a new Excel file
Open the .CSV file with a text editor e.g. Notepad++
Copy
Select cell A1
Method 1
Click on Paste button
Select ''Use Text Import Wizard"
Method 2
Paste into Excel
Select column A
Use function ''Text to columns'' on Data ribbon.
Same steps
The wizard starts
Click '''Next'''
Change ''Delimiters'' to '''Comma'''
Click '''Next'''
Change ''Column data format'' to ''Text'' and verify that the format is set
Click '''Finish'''
Save as xlsx
Close and open the file in order to verify that the data still has the correct format
{{NavBox Technical Notes}}
[[Category:NAA]]
Therefore check carefully the result in Excel before sharing the export result with others. This page describes a word around for this Excel behaviour.}}
Export
Open a new Excel file
Open the .CSV file with a text editor e.g. Notepad++
Copy
Select cell A1
Method 1
Click on Paste button
Select ''Use Text Import Wizard"
Method 2
Paste into Excel
Select column A
Use function ''Text to columns'' on Data ribbon.
Same steps
The wizard starts
Click '''Next'''
Change ''Delimiters'' to '''Comma'''
Click '''Next'''
Change ''Column data format'' to ''Text'' and verify that the format is set
Click '''Finish'''
Save as xlsx
Close and open the file in order to verify that the data still has the correct format
{{NavBox Technical Notes}}
[[Category:NAA]]