IssueRaiser

If you put the apostrophe in front of a number, and save it as csv, that works.

If you put the apostrophe in front of a number, and save it as csv, that works. But if you reopen that exact same file, Excel will still misinterpret the number. The issue here was that there's no way to let Excel know that this value in this CSV file is not a number. The only way around it that I know of is to stick with xlsx, which has its own pain points.

Posted by yen223 on Jun 4, 2015, 10:34 AM

Tags

Related issues

Raise real-world problems, find people facing the same issue, and discuss solutions.6,000 issues0 comments

hackernews (Other)

If you put the apostrophe in front of a number, and save it as csv, that works.

yen223Jun 4, 2015, 10:34 AM

If you put the apostrophe in front of a number, and save it as csv, that works. But if you reopen that exact same file, Excel will still misinterpret the number. The issue here was that there's no way to let Excel know that this value in this CSV file is not a number. The only way around it that I know of is to stick with xlsx, which has its own pain points.

Comments (0)

No comments yet. Start the discussion.

Comment on this issue