I have a gridview export to .csv file. When I export data, if there is a value like 10-10 and it open in excel it is shown as "10-oct". What do I do to get it to show up as "10-10"?
Add a comment
|
7 Answers
Though this has only been tested with Excel 2003 and could cause issues elsewhere, this worked for me:
1,3,10-10,a /* Displayed as 10-Oct */ 1,4, 10-10,b /* Displayed as 10-10 (note the leading space)*/ 1,3,10-10 ,a /* Displayed as 10-Oct */
Comments
You can tell Excel the cell is TEXT and not a Date. Of course, doing this you will need to save it as XLS file.
Right Click > Format Cells > Under Number tab > Select Text instead.
Comments
Similar to what Austin suggests, you can prepend the value with a single quote (') which escapes automatic formatting and treats the contests as TEXT:
1,3,'10-10,a
As noted in the comments though, this solution works in some programs, but not all versions of excel. If this is extremely important, you may need to consider exporting directly to .xls or some other rich format.
1 Comment
Austin Salonen
I'll give you an upvote but with this note: on Excel 2003 this displayed the
' and that may not be with the OP wants.Isn't that Excel just going "oh that looks like a date"?
Another application viewing the data may not try to interpret it as much.
Comments
Right click on the column in excel, click Format, and then set it to "text" instead of "general".
Comments
If you're going through the Import Wizard, you can tell Excel exactly how to interpret each column.
Comments
If you change the data in the .csv file as follows ...,=”10-10”,... This will be displayed in Excel as ...,10-10,...
Excel will have kept the data as a formula, but copying the column and using paste special values will get rid of the formula but retain the formatting
Comments
