开发者

Tsv table has some dates being expressed with pound-sign

开发者 https://www.devze.com 2023-03-25 20:52 出处:网络
For an internal database I\'m building, I have a开发者_如何学C sqlite database, and I want to use python to export it into a tsv file.The current problem is that some of my dates are being replaced wi

For an internal database I'm building, I have a开发者_如何学C sqlite database, and I want to use python to export it into a tsv file. The current problem is that some of my dates are being replaced with '######', and when double-clicked, become actual dates. Could somebody please help?

Note: Nothing else changes, including type (they're both date, as excel 2007 indicates).

Tsv table has some dates being expressed with pound-sign

Tsv table has some dates being expressed with pound-sign

If anyone wants to see the python source code, please comment, but I don't currently see a reason as to why I need to post it.


you mean the #### appear in Excel?

This is a common issue: when Excel cannot display the whole value of a cell, it displays ### until it can show the whole value. This is display only.

STFW for more explanation.

0

精彩评论

暂无评论...
验证码 换一张
取 消