1 Answer, 1 is accepted
0
Hello Ramesh,
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:
Stop Excel from automatically converting certain text values to dates
Hope it helps.
Regards,
Ivan Hristov
Telerik
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:
Stop Excel from automatically converting certain text values to dates
Hope it helps.
Regards,
Ivan Hristov
Telerik
Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.