I have a data column(datatype:nvarchar) which has a value as 1-20 when exported to csv format column values is showing as "20-Jan".
instead of 1-20.
Please help in solving the issue.
1 Answer, 1 is accepted
answered on 28 May 2014, 09:09 AM
When exporting to CSV, the values of your report items are exported "as is" without additional conversion. You can see the actual exported values if open your CSV file with a text editor like Notepad or Notepad++.
Usually this type of conversion happens when you open a CSV file with Microsoft Excel and it automatically changes the numbers to dates wherever it seems appropriate. As a workaround you can import your file from Excel's Data menu and explicitly set the column type using the import dialog. You can see some workarounds in the following forum discussion: