Changes

Open CSV in Excel

1 byte removed, 12:02, 7 April 2015

no edit summary

{{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.}}

{|

|- valign="top"

|}

~~{{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~~ Below we describe a workaround for this '''Excel''' behaviour.}}

<ol>

<li>[[Export Search Result]].</li>

<li>Close the Excel file and open the file again before you share it in order to verify that the data still has the correct format.</li>

</ol>

[[Category:NAA]]

← Older edit

Dionysia

NoPublic, bureaucrat, administrator

4,913

edits