Hi all,
I have a column in my radgrid called 'academic year' with values '01/02', '02/03', 03/04'..... etc
When I export to CSV, the above values become '01-Feb', '02-Mar', '03-Apr' .... etc.
Instead of exporting the value as text, it is considering it as date. Could you please suggest how can I solve this issue.
Thanks
I have a column in my radgrid called 'academic year' with values '01/02', '02/03', 03/04'..... etc
When I export to CSV, the above values become '01-Feb', '02-Mar', '03-Apr' .... etc.
Instead of exporting the value as text, it is considering it as date. Could you please suggest how can I solve this issue.
Thanks
1 Answer, 1 is accepted
0
Hello Anita,
The values in your CSV file are automatically parsed by Microsoft Excel and there is no way to avoid it. You can try the following:
- change the date format so it can't recognize it
- change the file extension to TXT and import the file manually
MS Office 2007 Excel Auto-Format Question
Regards,
Daniel
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
The values in your CSV file are automatically parsed by Microsoft Excel and there is no way to avoid it. You can try the following:
- change the date format so it can't recognize it
- change the file extension to TXT and import the file manually
MS Office 2007 Excel Auto-Format Question
Regards,
Daniel
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.